Concept explainers
Create an ER diagram that correctly describes the
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 images
- Write the proper sequence of activities for the design of a video rental database. (The initial ERD was shown in Figure 9.9.) The design must support all rental activities, customer payment tracking, and employee work schedules, as well as track which employees checked out the videos to the customers. After you finish writing the design activity sequence, complete the ERD to ensure that the database design can be successfully implemented. (Make sure that the design is normalized properly and that it can support the required transactions.)arrow_forwardASSESSMENT 02 1. You are required to design and implement a database system for a pharmacy shop with only one branch. The following is the description from the manager, Mr. Seth Akoto. "here, medicines that require prescriptions are sold only to people that have prescriptions. It is the pharmacy attendant that serves customers when they enter the pharmacy. Usually, people walk in and either give the prescription or mention the medicine they wish to purchase. The worker then searches to see if the medicine is in stock. If in stock, worker accepts payment from customer and gives the medicine and a receipt to the customer.“ 1. Determine all the entities from the description given by Mr. Akoto. 2. Assuming Mr. Akoto only wants a database system that would keep records of medicine{name of medicine, amount in grams in stock} and purchases{medicine bought, amount in grams bought, who attended to customer, when it was sold, contact and name of customer that bought the medicine} a. Draw and ER…arrow_forwardTask Description: consider the following relations for a university: Student (sid: integer, sname: string, GPA: real, dateOfBirth: date) Department (did: integer, dname: string, capacity: integer) Course (cid: integer, cname: string, credit: integer) Enroll (studentID: integer, courselD: integer, departmentID: Integer, enrollmentDate: date) studentlD, courselD, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively.arrow_forward
- You want to develop a program for the FBI to assist in crime investigation. In such crimes, investigators create a crime board to model the relationship between the different suspects, pieces of evidence and witnesses involved in the crime. You need to model these profiles in a way to answer questions such as -Does suspect A have a direct or indirect relation with suspect B? Describe a 1. data structure that you should use. 2. How you will set it up (initial state ). 3. Briefly state how your algorithm should function.arrow_forwardUse MySQL Workbench to create an EER diagram for a database named school_db that stores information about professors, students, and their courses. A table for professors that includes name, department, and birth date. A table for students that includes name, start date, and major. A table for classes that includes course name, course code, professor, start date, and end date. Pick smart data types for all of the required fields. Don’t forget about primary keys. You will need a fourth table for joining purposes. You need to figure out what gets joined with this fourth table. All four tables must show the correct relationships (i.e the primary keys and foreign keys need to match up) Screen capture (or Export an image) of your diagram and paste the image below.arrow_forwardDesign EERD schema for the system.arrow_forward
- Using the Crow’s Foot Diagrram technique, draw a database design for the attached database.arrow_forwardSo I need help creating a schema for my data managment class. I need someone to inspect my code and make any necessary adjustments........arrow_forwardDraw the ER diagram based on the following specification. A tutorial school is using a database to manage information about teachers, courses, and students. Each teacher is identified by staff_id, has a name, an email address, and a phone number. Each student is identified by student_id, has a name, an email address, and a registration date. Each course is identified by course_id, year, and semester. In addition, each course has a name. Each course is associated with multiple lessons. A lesson has a lesson number, a location, a date, a start-time, and an end-time. Lesson numbers are sequentially numbers, starting from 1, generated separately for each course. Each teacher teaches at least one course. Each student takes at least one course. Each course is taught by one teacher. Each course can be taken by many students.arrow_forward
- Design the UML class diagram to support the system below and upload a picture of your diagram. Used Class Material Website: You are designing a website where students can resale their used material for a course. A course may have multiple sections. The course material is specific to each section of a class. Not all course may require class materials, but they may require many of them. A student can have many used materials for sale. The class material can be either: · Textbook: which has a price(mandatory), title(mandatory), authors(optional), edition(optional) · Software: which has a price(mandatory), title(mandatory), publisher(optional), and also its operating system (mandatory) · Equipment: which has a price(mandatory), title(mandatory), description(mandatory) All class material can be either available or sold. Do a class diagram with: 1. all the classes , 2. their associations 3. their multiplicity . 4. For each classes, where are the…arrow_forwardDraw UML class diagram according to descriptions given below. Please include appropriate labeling and multiplicity in your diagrams. You do not need to include the attributes and operations for the classes. A Rectangle object is composed of exactly four Line objects A Customer object is able to initiate zero or more Transaction A Student Object must enrolls in at least one, at most five Subject A Mouse object is kind of a Rodent A Rodent object is a kind of Mammal Object.arrow_forwardYou just started your summer internship with NU Bank as part of its growing development team. Your first assignment is to design and build two classes that are to be utilized in both the banks website and internal applications. The first is a loan class representing a loan contract. The second is a customer class representing the individual receiving the loan. You will be building the business logic classes, so you don’t have to worry about forms for communicating with the user or data access classes to communicate with the database. To test your classes, you will use them in a test application. The requirements for your classes and the testing application are as follows:• You are to design and build 2 components of the Loan Processing System (LPS). There will be one class to represent loan contracts, and another to represent customers.• Each class should have at least 2 members and 2 methods.• The LPS will need to be able to check that the customer is at least 21 years old. A…arrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education