Question: Consider the above database defined by the relations: STUDENT, COURSE, SECTION, GRADE_REPORT, PREREQUISITES. STUDENT Name Student Number Class Major Smith CS CS Department CreditHours Brown

Consider the above database defined by the relations: STUDENT, COURSE, SECTION, GRADE_REPORT, PREREQUISITES. STUDENT Name Student Number Class Major Smith CS CS Department

Consider the above database defined by the relations: STUDENT, COURSE, SECTION, GRADE_REPORT, PREREQUISITES. STUDENT Name Student Number Class Major Smith CS CS Department CreditHours Brown COURSE CourseName Intro to Computer Science Data structures Discrete Math Database CourseNumber CS1310 CS3320 MATH2410 CS3380 CS MATH CS SECTION Year Instructor King 92 Sectionidentifier CourseNumber Semester 85 Math2410 Fall CS1310 Fall 102 CS3320 Spring 112 MATH2410 Fall 119 CS1310 Fall CS3380 Fall Anderson Knuth Chang Anderson Stone 135 2280 GRADE-REPORT Grade StudentNumber 17 17 SectionIdentifier 112 119 85 00 00 102 136 00 PREREQUISITES CourseNumber CS3380 CS3380 CS3320 PrerequisiteNumber CS3320 MATH2410 CS1310 1) Give the schema of each relation. 2) Find a suitable primary key for each relation. 3) Using the schema you obtained in 1), draw the foreign key constraints for the database. Consider the above database defined by the relations: STUDENT, COURSE, SECTION, GRADE_REPORT, PREREQUISITES. STUDENT Name Student Number Class Major Smith CS CS Department CreditHours Brown COURSE CourseName Intro to Computer Science Data structures Discrete Math Database CourseNumber CS1310 CS3320 MATH2410 CS3380 CS MATH CS SECTION Year Instructor King 92 Sectionidentifier CourseNumber Semester 85 Math2410 Fall CS1310 Fall 102 CS3320 Spring 112 MATH2410 Fall 119 CS1310 Fall CS3380 Fall Anderson Knuth Chang Anderson Stone 135 2280 GRADE-REPORT Grade StudentNumber 17 17 SectionIdentifier 112 119 85 00 00 102 136 00 PREREQUISITES CourseNumber CS3380 CS3380 CS3320 PrerequisiteNumber CS3320 MATH2410 CS1310 1) Give the schema of each relation. 2) Find a suitable primary key for each relation. 3) Using the schema you obtained in 1), draw the foreign key constraints for the database

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!

Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. What are the referential integrity constraints that should hold on the schema? Write appropriate SQL DDL statements to...

Q1. Think of different users for the database shown in Figure 1. What types of applications would each user need? To which user category would each belong, and what type of interface would each need?...

2) Specify the following questions against the database in the figure above using relational algebra: a) Give a list of the courses (names, numbers) that give more than 3 points (credit hours) b)...

Specify the following queries in SQL on the database schema of figure 1. [ 15 marks] Retrieve the names of all senior students majoring in CS (computer science). Retrieve the names of all courses...

QUESTION NO. 3: MANDATORY/ OPTIONAL / BONUS (5 Points) Given the following database sample instance, write the following SQL queries: (CLO3) Student Name Student number Class Major Smith 17 CS Browns...

HW1 Answers to Selected Exercises 1.8 - Identify some informal queries and update operations that you would expect to apply to the database shown in the figure below. Figure 1.2 A database that...

b. Can you restructure the columns in this database - without adding or deleting any tables , so that to minimize the number of changes that cascade throughout the tables when such a renaming of a...

Given the following database sample instance, write the following SQL queries: (CLO 3) Student Name Student_number Class Major Smith 17 1 CS Brown 8 2 CS Course Course_name Course_number Credit_hours...

For the given database tables, write SQL queries for each of the questions below. 1. For each section taught by professor King, retrieve the course number, semester, year, and number of students that...

What are the criteria that should be applied when choosing among candidate application software packages?

Bell, Inc. buys 1,000 computer game CDs from a distributor who is discontinuing those games. The purchase price for the lot is $8,000. Bell will group the CDs into three price categories for resale,...

When thinking about symptoms vs . causes of financial distress for a borrower, which of the following are most likely to appear as "symptoms" ( or lagging indicators ) ? Select all that apply. A...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

a lack of management responsibility concerning ecological issues and the utilization of scarce resources.

a neglect of quality in relationship to international competitors;

full employment policies, and therefore lack of concern with negative appraisal, as salaries varied very little and there was no danger of unemployment;