Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q 1 : A teacher can teach many courses and a course can be taught by many teachers. A course has course _ id ,
Q: A teacher can teach many courses and a course can be taught by many teachers. A course has courseid title and credithour and a teacher has Tid name, Date of Birth DOB street, city, designation, Total salary. You have to record the semester and year of teaching of these courses, remuneration of the course, section, number of students, course fee per student.
Draw the ERD and transform the ERD into relational schema. Write SQL to create the tables according to the relation schema
Q: A mother can have many children and a child must have only one mother. A mother has birth registration MBRN number and a child have also birth registration number CBRN A mother is described by name, number of sons, number of daughters, total child, date of birth, profession and income. A child is described by name, date of birth, birthtime height and birthtime weight, gender.
Draw the ERD and transform the ERD into relational schema. Write SQL to create the tables according to the relation schema
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