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…

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

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.