A driving school wants to build a database to manage the theoretical traffic laws tests of its students. After discussing with the manager of the driving school, we have documented the following requirements:Each student is identified by a unique number and is characterized by his last name, first name, an address, and date of birth.Each student may attend several training sessions (as much as he needs).Each session has a unique number and is characterized by a specific date and time.For each training session, the manager chooses a series of questions from a CD.Each CD is identified by a number and is characterized by a publisher name.Each CD consists of 6 series of questions, numbered from 1 to 6 and each series consists of 40 questions.Each question is identified by a number and is characterized by the question text, answer, level of difficulty and a theme.The same question may appear in several series with an order number for each series. For example, question number 35 may appear as question number 2 in series 5 of CD 15 and as question number 12 in series 3 of CD 4.The same series may be used several times in different sessions.At the end of each session, each student obtains the number of wrong answers he has given.When a student obtains in the last 4 sessions at which he assisted less than 5 wrong answers, the school manager allows him to pass the theoretical test.Each test is identified by a number and is characterized by a date and time.Students who get more than 5 wrong answers on the exam fail and must repeat the training sessions before passing a new exam.Draw the corresponding E/R diagram by using the (min, max) notation. Make sure to show which attribute (or collection of attributes) is (are) the identifier. State all assumptions you make. NOTE: THE IMAGE ATTACHED BELOW IS AN EXAMPLE OF HOW THE ER DIAGRAM SHOULD LOOK LIKE. CNameCOfficeCPhoneDEAN(1,1)COLLEGERank1OfficeIPhoneld NameINSTRUCTOR(0,1)(0,N)CStartDate(0,1)(0,N)CHAIR(1,1)ADMINS(1,1)MName(1,1)FName LNameEMPLOYSSidDNameSName(0,N)DOBAddrDCodeDEPTHASSTUDENTPhoneDOffice(0,N)(0,1)MajorDPhone(0,N)(0,N)GradeTEACHESOFFERSTAKES(1,1)(5,N)(1,1)SecldCCodeCOURSESECSSECTION SecNoCredits(0,N)(1,1)SemCoNameCDescDays TimeYearLevelCRoomBldgRoomNo

import matplotlib.pyplot as plt import networkx as nx # Define the graph for the ER diagram…

Answered: CName COffice CPhone DEAN (1,1) COLLEGE…

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 4RQ

See similar textbooks

Related questions

Question

A driving school wants to build a database to manage the theoretical traffic laws tests of its students. After discussing with the manager of the driving school, we have documented the following requirements:

Each student is identified by a unique number and is characterized by his last name, first name, an address, and date of birth.
Each student may attend several training sessions (as much as he needs).
Each session has a unique number and is characterized by a specific date and time.
For each training session, the manager chooses a series of questions from a CD.
Each CD is identified by a number and is characterized by a publisher name.
Each CD consists of 6 series of questions, numbered from 1 to 6 and each series consists of 40 questions.
Each question is identified by a number and is characterized by the question text, answer, level of difficulty and a theme.
The same question may appear in several series with an order number for each series. For example, question number 35 may appear as question number 2 in series 5 of CD 15 and as question number 12 in series 3 of CD 4.
The same series may be used several times in different sessions.
At the end of each session, each student obtains the number of wrong answers he has given.
When a student obtains in the last 4 sessions at which he assisted less than 5 wrong answers, the school manager allows him to pass the theoretical test.
Each test is identified by a number and is characterized by a date and time.
Students who get more than 5 wrong answers on the exam fail and must repeat the training sessions before passing a new exam.

Draw the corresponding E/R diagram by using the (min, max) notation. Make sure to show which attribute (or collection of attributes) is (are) the identifier. State all assumptions you make.

NOTE: THE IMAGE ATTACHED BELOW IS AN EXAMPLE OF HOW THE ER DIAGRAM SHOULD LOOK LIKE.

CName
COffice
CPhone
DEAN
(1,1)
COLLEGE
Rank
1Office
IPhone
ld Name
INSTRUCTOR
(0,1)
(0,N)
CStartDate
(0,1)
(0,N)
CHAIR
(1,1)
ADMINS
(1,1)
MName
(1,1)
FName LName
EMPLOYS
Sid
DName
SName
(0,N)
DOB
Addr
DCode
DEPT
HAS
STUDENT
Phone
DOffice
(0,N)
(0,1)
Major
DPhone
(0,N)
(0,N)
Grade
TEACHES
OFFERS
TAKES
(1,1)
(5,N)
(1,1)
Secld
CCode
COURSE
SECS
SECTION SecNo
Credits
(0,N)
(1,1)
Sem
CoName
CDesc
Days Time
Year
Level
CRoom
Bldg
RoomNo

Expert Solution

Step by step

Solved in 2 steps with 4 images

SEE SOLUTION Check out a sample Q&A here