Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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 Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter9: Database Design
Section: Chapter Questions
Problem 7P
See similar textbooks
icon
Related questions
Question
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 three attempted questions will be marked. Indicate in your answer sheet clearly which three questions you are attempting Question Al The relational model below (in Figure 1) represents a database system of an oducation center. Trainer Assigned to T traner 0 I noganmeo 1 Trainer D Dateofirth Expertise Programme School Programme D School0 Description School Name Type Location School D Figure I: Education Center Database (a) Identify cach relationship between tables Trainer, Progrumme and School, then write all she business rules in this n (b) Suppose a new trainer is hired and immediately assigned to ONE new programme at a new school and to THREE other already existing programmes. How many rows must be added to the database to reflect 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.
Transcribed Image Text: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 three attempted questions will be marked. Indicate in your answer sheet clearly which three questions you are attempting Question Al The relational model below (in Figure 1) represents a database system of an oducation center. Trainer Assigned to T traner 0 I noganmeo 1 Trainer D Dateofirth Expertise Programme School Programme D School0 Description School Name Type Location School D Figure I: Education Center Database (a) Identify cach relationship between tables Trainer, Progrumme and School, then write all she business rules in this n (b) Suppose a new trainer is hired and immediately assigned to ONE new programme at a new school and to THREE other already existing programmes. How many rows must be added to the database to reflect 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.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Dataset
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS