Related questions
Concept explainers
Draw the Enhanced Entity–Relationship (EER) model and the relational schema for the case study below:
This case study describes a company called HomeCinema, which rents out videos to its members. The first branch of HomeCinema was established in 1982 in Jeddah but the company has now grown and has many branches throughout the country. As HomeCinema has grown, so has the difficulties in managing the increasing amount of data used and generated by the company. To ensure the continued success of the company, the Director of HomeCinema has urgently requested that a
The data held on a branch of HomeCinema is the branch address made up of street, city, state, and zip code, and the telephone numbers (maximum of 3 lines). Each branch is given a branch number, which is unique throughout the company.
Each branch of HomeCinema has staff, which includes a Manager, one or more Supervisors, and a number of other staff. The Manager is responsible for the day-to-day running of a given branch. Each branch has several Supervisors and each Supervisor is responsible for supervising a group of staff. The data held on a member of staff is his or her name, position, and salary. Each member of staff is given a staff number, which is unique throughout the company.
Each branch of HomeCinema is allocated a stock of videos. The data held on a video is the catalog number, video number, title, category, daily rental rate, purchase price, status, and the names of the main actors (and the characters played), and the director. The catalog number uniquely identifies each video. In most cases, there are several copies of each video at a branch, and the individual copies are identified using the video number. A video is given a category such as Action, Adult, Children, Thriller, Horror, or Sci-Fi. The status indicates whether a specific copy of a video is available for rent.
Before renting a video from the company, a customer must first register as a member of a local branch of HomeCinema. The data held on a member is the first and last name, address, and the date that the member registered at the branch. Each member is given a member number, which is unique across all branches and is used even when a member chooses to register at more than one branch. The name of the member of staff responsible for processing the registration of a member at a branch is also noted.
Once registered, a member is free to rent videos, up to a maximum of 10 at any one time. The data held on each video rented is the rental number, the member’s full name and member number, the video number, title, and daily rental cost, and the dates the video is rented out and returned. The rental number is unique throughout the company.
Step by stepSolved in 3 steps with 2 images
- Draw clearly from existing scenario text the Entity Relationship Diagram (ERD) “There is a group of employees who have run the website. Three admins are responsible to check registration forms filled by babysitters. An accountant is responsible to check fees payments. All these employees are supervised by the manager. Each babysitter can register on the website one time by filling in her data including first and last names, qualifications, fee rate per hour (25 SAR per Hour), contact information, address, photo, and years of experience. The system will issue for her id and registration date. Mothers can make booking as many as they need. For each time, they must fill in their names, contact information, address, number of children, the date and time (e.g. from 2:00 PM to 4:PM) of booking. The website will generate the booking report including mother’s data, babysitter’s contact data, number of booked hours, fee rate per hour, fees total amount, and tax (%5). To make a…arrow_forwardWhat does an associative entity model? a.) Associative entities model pure relationships rather than entities. b.) Associative entities model entities that are independent. c.) Associative entities model the real-world scenarios of ways to look up data. d.) Associative entities model attributes and how they are linked to entities.arrow_forwardPrepare an E-R diagram for a real estate firm that lists property for sale. Identify all entities (supertype/subtype), attributes (optional/required), unique identifiers, relationships and relationships cardinality and optionality. Resolve any M-M relationship you find. • The firm has several sales offices in several states. Each sales office has Office_Number and a Location. • Employees are assigned to work in different sales offices. Each employee has an ID and Name. • An employee must be assigned to only one sales office. For each sales office, there is always one employee assigned to manage that office. For each manager we record the start date of the management job. • The firm lists properties for sale. Each property has an ID, description and Location. Each unit of property must be listed with one (and only one) of the sales offices. A sales office may have any number of properties listed. • Each unit of property has one or more owners. owners have ID and Name. An owner may own…arrow_forward
- You have been asked to design and implement a database for CTU, which includes 3 entities (tables), as follows: Students Faculty Courses Part 1 Create a Word document that includes the following: Identify at least 3 attributes for each entity, including the following: Student's entity should have an attribute for the program the student is enrolled in. Faculty should have an attribute identifying their rank. Properly identify all of the primary keys (use solid underlines). Create an entity relationship diagram (ERD) from the entities. You may use SmartDraw, Visio, Erwin, or even Word to draw the diagram. Take a screenshot (no need if you use Word), and insert it into the Word document. Part 2 Use Microsoft Access to implement the database that you designed in Part 1, and include the following: Create the Student, Faculty, and Course tables in Access. Add a few instances in each table. Create 2 queries for the following objectives: Find the student names for all students who are in the…arrow_forwardConsider the E-R diagram for a university database as shown in Figure 1. What is NOT true about instructorand student?(a) An instructor can advise more than one students.(b) A student can be advised by more than one instructors.(c) A student may not have an instructor as advisor.(d) none of the above.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
- b) An ER/EER diagram modeling your database (use appropriate symbols, and don’t forgetassociative entities where appropriate). This will be based on the business rules you created, somake sure you’ve written clear rules! (30 points)• Feel free to use an appropriate design tool you would like for your ER diagram (e.g.http://draw.io), or do it by hand and scan it in; just make sure it is legible and that itfollows the notation/style taught in class. Do NOT use other styles, such as “Visio”notation that includes PK/FK.c) A list of normalized relations (using the notation from class) that is based on your ER diagram.Be sure to include foreign keys, etc. (30 points)arrow_forwardIn order to be used as a primary key, which of these characteristics must an attribute possess with respect to a single instance of the entity? There must be a maximum of one attribute instance. There must be many instances of the attribute. There must be at most one entity instance that each attribute instance describes. There must be at least one instance of the attribute. There must be zero or more instances of the attribute.arrow_forwardSuppose that we wish to keep a genealogy. The information we wish to record about each person includes their name, date of birth, phone number, and degrees obtained . We also need to keep track of the mother, father, and children of each person. Draw a complete Entity-Relationship diagram. You must include all the details, sad as keys, weak entities (if any), cardinality constraints, etc. Your diagram must avoid redundancy.arrow_forward
- What is entity-relationship modeling, and how is it used in the context of data modeling?arrow_forwardDecipher the business rules for this ER Diagram :arrow_forwardUsing er assistant create an Entity Relationship Diagram(ERD) with appropriate entries, relevant attributes, and relations to support the following business rules, and write a few lines to defend your erd. You need to design a database to keep track of clubs at a high school. Attributes: A student may only join one club Some students do not join at all Club needs to have one student Need to capture students: Name Address Year of grad All Phone numbers Club name Club advisor Meeting datesarrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON 
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education