Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. 140 Points] Assume a private school with the following information There are persons. each person is identified by a SSN. Additionally he/she has a
2. 140 Points] Assume a private school with the following information There are persons. each person is identified by a SSN. Additionally he/she has a name, gender, dob, address, email and cell number. There are tutors. Each tutor is identified by an id. Additionally he/she has an hourly rate and inherits all the properties of a person. Also, a tutor can have only one specialty which could be Math, Physics, English, etc. .There are students. Each student is identified by an ID. Additionally, a student inherits all the properties of a person. A private lesson is at a certain date and time Each private lesson is given by a tutor to a student. Many tutors can give lessons to the same student. a) Draw the E/R diagram of a DB design for the above information
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started