Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please give the correct answer 4. A university database schema is given below: classroom(building, room_number, capacity) department(dept_name, building, budget) course(coursesid, title, dept_name, credits) instructor(ID), name,
please give the correct answer
4. A university database schema is given below: classroom(building, room_number, capacity) department(dept_name, building, budget) course(coursesid, title, dept_name, credits) instructor(ID), name, deptname, salary) section(course_id, secid, semester, year, building, room_number, timesslot_id) teaches ID, courseid, secid, semester, year ) student(ID, name, dept_name, tot_cred) takes (ID, course jid, sec jid, semester, year, grade) advisor (SJD,i in ) timesslot(time-slotid, day, start_time, end_time) prereq (courseid, prerequid) Find all keys and write the DDL for the above schema. Write SQL command for class routine. 4. A university database schema is given below: classroom(building, room_number, capacity) department(dept_name, building, budget) course(coursesid, title, dept_name, credits) instructor(ID), name, deptname, salary) section(course_id, secid, semester, year, building, room_number, timesslot_id) teaches ID, courseid, secid, semester, year ) student(ID, name, dept_name, tot_cred) takes (ID, course jid, sec jid, semester, year, grade) advisor (SJD,i in ) timesslot(time-slotid, day, start_time, end_time) prereq (courseid, prerequid) Find all keys and write the DDL for the above schema. Write SQL command for class routine
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