Answer any THREE out of the FOUR questions in this section in the answer sheet provided.Each question carries 20 marks. If you answer more than three questions, only the first threeattempted questions will be marked. Indicate in your answer sheet clearly which threequestions you are attemptingQuestion AlThe relational model below (in Figure 1) represents a database system of an oducation center.TrainerAssigned toT traner 0I noganmeo1 Trainer DDateofirthExpertiseProgrammeSchoolProgramme DSchool0DescriptionSchool NameTypeLocationSchool DFigure I: Education Center Database(a) Identify cach relationship between tables Trainer, Progrumme and School, then write all shebusiness rules in this n(b) Suppose a new trainer is hired and immediately assigned to ONE new programme at a newschool and to THREE other already existing programmes. How many rows must be added tothe database to reflect this change?State the TOTAL number of rows to be added in the database and then list out ALL thoseaffected tables and the number of added rows in cach affected table.

Relationship between tables: There is M: N relationship between the Trainer table and the Programme…

Answer any IHREE out of the FOUR questions in this section in the answer sheet provided. Each question carries 20 marks. If you answer more than three questions, only the first three attempted questions will be marked. Indicate in your answer sheet clearly which three questions you are attempting Quation Al The relational model below (in Figure 1) represents a database system of an education center. Trainer Assigned, to Trainer D Trainer 0 Datroith Programmeo Expertise Programme School Programme D Description 1school0 School Name Type Location School D Figure 1: Education Center Database (a) Idkntify cach relationship between tables Trainer, Progrumme and School, then write nll he business rules in this model. (b) Suppose a new trainer is hired and immediately assigned to 0NE new programme at a new school and to IHREE other already existing programmes. How many rows must be added to the database to refket this change? State the TOTAL number of rows to be added in the database and then list out ALL those affected tables and the number of added rows in cach affected table.

Answer any IHREE out of the FOUR questions in this section in the answer sheet provided. Each question carries 20 marks. If you answer more than three questions, only the first three attempted questions will be marked. Indicate in your answer sheet clearly which three questions you are attempting Quation Al The relational model below (in Figure 1) represents a database system of an education center. Trainer Assigned, to Trainer D Trainer 0 Datroith Programmeo Expertise Programme School Programme D Description 1school0 School Name Type Location School D Figure 1: Education Center Database (a) Idkntify cach relationship between tables Trainer, Progrumme and School, then write nll he business rules in this model. (b) Suppose a new trainer is hired and immediately assigned to 0NE new programme at a new school and to IHREE other already existing programmes. How many rows must be added to the database to refket this change? State the TOTAL number of rows to be added in the database and then list out ALL those affected tables and the number of added rows in cach affected table.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Question 6 V Saved Problem 4-7 will use the same database. Let a database application be Model - ( Supplier, Products, Supplier_information, Project), Which contains the information that you will buy products (Coke, Apples, .) from suppliers (Walmart, K-mart,) Multiple products will be used in the Projects (basket ball team, volley ball team, ). Product costs are the main factors for selecting a supplier. Supplier information contains additional information about a supplier (Emergeney contact person, emergency contact phone, This Supplier_information will be updated from time to time; for example, Emergency contact person can be changed. The business rule required the database to keep all of the old Emergency contact person. What is the relationship between Supplier and Project? One-to-many relationship Many-to-many relationship
LOGICAL DATABASE DESIGN The above EER-Diagram represents a University Library Membership (see Diagram 5). A member can borrow as many books from the library. Derive relations for logical model from the above EER-Diagram. Please identify any primary key or foreign key in the derive relations (if applicable).
Which of the following is a key part of conceptual design in an entity relationship model? This model resolves the many-to-many relationships to multiple one-to-many relationships. This model adds all of the attributes for each entity. This model converts attributes into columns. This model does not depend on the database management software or the hardware used to implement the model.
PART 4 Translate the following ER Diagram into a relational database schema. COST REGISTRATION VIN FITTED VEHICLE LEGAL N ID OPTION TAX DISC DURATION M EXPIRY N COST 28 DEPENDS CLASS TYPE NOTES
Draw a clear and complete ER diagram
The entity relationship diagram below models the components of a database belonging to TrueHealth, a network of medical centers. The database allows TrueHealth to keep track of doctors at each practice and their patients. Patient PK Pat ID Consultation Doctor PK,FK1 Doc_ID PK Doc ID 1..1 0.. 1..1 Pat_Name PK, FK2 Pat ID Doc_Name Pat Age Con_Date Doc_EmployDate Pat_Gender FK Prc_ID 0..* 1..1 Practice PK Prc ID Prc_Name Prc_YearEstablished Prc_Province Write SQL statements for the following: Create all the necessary tables. Name the tables; and all their attributes appropriately. Insert TWO records into each of the tables created to demonstrate that you have created them correctly. List all the TrueHealth practices based in Gauteng. List, in alphabetical order, the names of all patients who had consultations after 01 January 2018. Which practice (by name) has the most recent hire (i.e. doctor with latest employment date)? Which doctor has had the least number of consultations? Give the…
Part Design a database for an Access Control System. The purpose of the system is to control who has access to which doors at what time. There are six entities in this database: ● ● Users Groups O A user can be assigned to more than one group. Doors AccessRules O Decides which Group has access to which Door at which TimeSchedule. Example: Group A can access the Front Door on Monday from 7am to 9pm. o o Example: Group B can access the Back Door on Saturday from 8am to 10pm. TimeSchedules To make it simple, we only need to pport Weekly Schedules. The TimeSchedules table has the following columns: Id O O DayOfWeek StartTime ■ EndTime o Example: a schedule with DayOfWeek-Monday, StartTime=7:00, EndTime=23:00 means this schedule grants access on Monday from 7am to 11pm. Entrance Logs O This table keeps a permanent record of which user accessed which door at what time. o The logs must remain valid even after the related records have been updated. For example, after user X is deleted, the…
List five properties of relations.
C. part, I need only ERD and relational diagram or nothing else. Plzz fast
Which of the following statements corresponds to the second normal form for an entity - relationship model in relational databases? A relationship must have only one key and the attributes můst have simple donains B A relationship must have a Kev, with simple domains for its attributes and all non-key attributes depend entirely on the key A relationship must have a key with static domains for its attributes which all depend on the key A relationship must have only one key with all attributes dependent on the key. A. D
The textual description nodan, describes a video rental company that wants to create one database of its activities. Drawing an ER chart sim meets the company's requirements. The company has stores throughout New York. What is stored about each pile is the telephone number and address which consists of street, city, house number and postcode. Each store is also assigned a number that is unique throughout the company. There is always a manager for each store. An employee thus has a specific role. If employees, they also store names and salary. Each employee has an employment number that is unique Each store has a video store. Information about the film / video that is of interest, video number, title, status and the names of the most important actors, and the director. The rental price for a film varies depending on which store you rent the film from.Of course, the role of a preson participant in one film may vary in another film Shelf numbers and number of copies of each film are also…
HOMEWORK #6 Consider the following flawed ER diagram representing clubs and their activities. name club Sponsor date time building room activity capacity description A club has a unique ID and a name. An activity has a date, a time, and a description, and is in a room. A room has a unique (building, room number) and a capacity. Each activity is sponsored by exactly one club. 1. Following the rules we studied, convert the ER diagram into a relational schema. 2. The resulting schema is not in BCNF. Identify a non-trivial functional dependency where the left- hand side is not a superkey. 3. Decompose into schemas that are in BCNF. 4. Modify the ER diagram so that it corresponds to the normalized schema and briefly explain what the problem was with the original design.