Question: Draw ERD and transform the ERD into relational schema and write DDL according to the relation schema for the following questions Q . 1 :
Draw ERD and transform the ERD into relational schema and write DDL according to the relation schema for the following questions
Q: A person is described by id name first name, middle name, last name multiple qualifications degree grade multiple trainings title country, duration present address street no street name, city and permanent address street no street name, city date of birth and age.
Q: There are many teachers in the university. Teacher has Id name, salary. Among the teachers, Head of the department is appointed for a certain period of time start date and end date A teacher may be appointed Head many times. In different times, different teachers are appointed as Head.
Q: A teacher can teach many courses and a course is taught by exactly one teacher. A teacher has id name and degree. A course has courseid title and credit.
Q: There are many foot ball teams participated in world cup A team has id and country. A team plays with another team in a particular date and a title of the play eg round semifinal etc.
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, designation salary. You have to record the semester and year of teaching of these courses by the teachers.
Q: A mother can have many children and a child must have only one child. A mother has birth registration MBRN number and a child have also birth registration number CBRN A mother is described by date of birth, profession and income. A child is described by date of birth, height and weight.
Q: An apartment must be owned by exactly one person and a person may own maximum one apartment. A person has NID, name, date of birth, street, city and income. An apartment has appid size, appname, floornumber, location and price.
Q: A course has courseid title and credithour. A section has secid semester and year. A course has many sections and a section has exactly one course. The section id cannot identify the section uniquely a section because the same section id is used for different courses. The section id semester and year jointly cannot identify a section uniquely. So section has no primary key.
Q: An instructor can advise many students but a student must have exactly one adviser. An instructor has id name, deptname and salary. A student has id name, street, city, CGPA and totcredit.
Q: A student can enroll a maximum of courses and a minimum of courses. A course can be enrolled by minimum students and a maximum of students. A student has id name, street, city, CGPA and totcredit. A course has courseid title and credithour.
Q: There are many projects developed by many students and supervised by instructors. An instructor can supervise many projects developed by many students but any projectstudent pair must be supervised by only one instructor. A project has Pid location and budget. A student has id name, street, city, CGPA and totcredit. A superviser has sid name, date of birth and salary.
Q: Explain the terms logical schema and physical schema.
Q: Explain data model.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
