Question: A university database schema is given : Find all keys and write the DDL for the above schema. Write SQL command for class routine. classroom

A university database schema is given :

Find all keys and write the DDL for the above schema. Write SQL command for class routine.

classroom (building, room_number, capacity) department(dept_name, building, budget) course (courseid, title, dept_name, credits) instructor(ID name, dept_name, salary) section(course_id, secid, semester, year, building, room_number, time_slot_id) teaches (ID, courseid, secid, semester, year) student(ID, name, dept_name, tot_cred) takes (ID, course id, sec id, semester, year, grade) advisor(s_ID, iJD) time_slot(time_slot_id, day, start_time, end_time) prereq(course_id, prereq_id )

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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,...

Problem 4: Rank (6 points) A rank of a collection of records assigns a 1 to the top-most value it is in 1st place), a 2 to the second highest value (2nd place), and so forth. If multiple records have...

Database questions. Needs to be in SQL Oracle. 1. Find the names and ids of the students who have taken exactly one course in the Spring 2010 semester. 2. Find the names and ids of the students who...

Problem 3 (Parts a-b are 3 points each, c-fare 4 points each; 22 points total) Here are some more challenging problems to try against the banking database. a) Generate a list of all cities that...

3.35 Using the university schema, write an SQL query to find section(s) with max- imum enrollment. The result columns should appear in the order "courseid, secid, year, semester, num". (It may be...

Problem 2 (Part a is 2 points, parts b-c are 3 points each; total is 8 points) Write SQL statements that define the following views. Make sure that all columns in each view's results have meaningful...

Do not answer if you cannot answer all of them. Problem 2. Answer 2.1-2.3 using university schema classroom (building, room number, capacity) department (dept name, building, budget) course (course...

**THE FOLLOWING IS THE ddl.sql SCHEMA*** create table classroom (building varchar(15), room_number varchar(7), capacity numeric(4,0), primary key (building, room_number) ); create table department...

SQL (10 pts.) Database creation and querying exercise. The schema, DDL, and instance for the University database from the textbook are provided in Appendix A. The electronic form of the DDL and...

takes ID course id sec id semester year grade student ID name dept_name tof_cred section course_id sec_id semester year building room_number time_slot_id course course_id title dept_name credits...

On January 1, 2011 Piper Co. issued ten-year bonds with a face value of $1,000,000 and a stated interest rate of 10%, payable semiannually on June 30 and December 31. The bonds were sold to yield...

The Bank gives an advertisement of 15% account that yields 15.56% annually. How often is the interest rate compounded from the following: O Quarterly O Monthly O Bimonthly O Annually

MSFT sells for $320 a share today. Its likely dividends per share and end-of-year stock price depend on the state of the economy by the end of the year as follows: Scenarios Probabilities Dividends...

Copenhagen Covered (B). Heidi Hi Jensen, a foreign exchange trader at J.P. Morgan Chase, can invest $5 million, or the foreign currency equivalent of the bank's short term funds, in a covered...

Explain why a sender should use short paragraphs in business messages. Tell what the average length of short paragraphs should be for (a) letters and memos and (b) reports. (Objective 3)

Give sentences unity. Rewrite the following long sentences making them concise and understandable. If needed, divide the content into more than one sentence to express only one main thought in each...

Use appropriate nontechnical words. Use an online or print dictionary to select nontechnical words to replace each of these technical words: (a) dividend, (b) prosthesis, (c) equity, (d) hypothesis,...