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
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
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 4RQ
Related questions
Question
A driving school wants to build a
- 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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 4 images
Recommended textbooks for you
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage