Question: Question 3 Database Schema from Relational model ( 10 marks) Consider the following University student record database STUDENT(StudSin, StudentNo, Name, Major, Bdate) DEPARTMENT(DeptName, DeptNo, location)

Question 3 Database Schema from Relational model ( 10 marks) Consider

Question 3 Database Schema from Relational model ( 10 marks) Consider the following University student record database STUDENT(StudSin, StudentNo, Name, Major, Bdate) DEPARTMENT(DeptName, DeptNo, location) COURSE(CourseNo, Coursename, CreditHr, DeptNo) ENROLL(StudentNo, CourseNo, SecNo, SemesterYear, Grade) BOOK_ADOPTION(CourseNo, SemesterYear, Book_ISBN) TEXT(Book ISBN, Book_Title, Publisher, Author) SECTION(SecNo, CourseNo, SemesterYear, EmpNo) INSTRUCTOR(EmpSIN, EmpNo, Name, DeptNo) PEREQUISITE(CourseNo, PreNo) i. Identify all foreign keys ii. Draw a relational database schema for the database showing all referential integrities. State any assumption you make (if any). Make sure you underline the primary key as shown in the question in your schema

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!

Write a query to find each customer who has an account at every branch located in Brooklyn Consider the bank database schema given below, where the primary keys are underlined. Write the SQL DDL...

Your company is a multi - department retail organization that operates both online and offline. The company has several departments, products, employees, customers, suppliers, inventory, and sales...

Hands - on skills in ASP.NET Core Instructions: 1 . General: This practical exam is designed to assess your hands - on skills in ASP.NET Core. Read each question carefully before proceeding. 2 ....

Formative Assessment 3 1 0 0 Marks Hands - on skills in ASP.NET Core Instructions: 1 . General: This practical exam is designed to assess your hands - on skills in ASP.NET Core. Read each question...

Question 1 : Setup and Basic Web Page ( 2 0 marks ) 1 . Create a new ASP.NET Core MVC project. 2 . Implement a basic home page with the following elements: Header with a logo . Navigation menu with...

Formative Assessment 3 1 0 0 Marks Hands - on skills in ASP.NET Core Instructions: 1 . General: This practical exam is designed to assess your hands - on skills in ASP.NET Core. Read each question...

Question 2 : Model - View - Controller ( MVC ) Structure ( 2 5 marks ) 1 . Implement an MVC structure for managing a list of Products. 2 . Model: Create a model class named Product with properties:...

Use the given graphs of f and to evaluate each expression, or explain why it is undefined. (a) f(g(2)) (b) g (f(0)) (c) (f o g (0)) (d) (g o f)(6) (e) (g o g)(- 2) (f) (f o f) (4) 2 2.

In 1996, the IASB revised IAS 12. Did that revision make the international standard for deferred tax accounting more or less similar to the U.S. standard?

Financial Analysis of the Chosen Company Stock ticker symbol, exchange where traded _ _ _ _ Pfizer _ _ _ _ _ Address of company headquarters _ _ _ _ _ _ _ _ _ Company phone number _ _ _ _ _ _ _ _ _ _...

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

Technology. You, as student body president,have been asked to emcee the Fourth Annual Senior Awards Banquet in three months. In this capacity, you will be introducing a local businessperson of your...

How can the Internet be helpful in a job search? (Objective 2)

What information should you list on your Experience inventory that will prepare you to write the Experience section of a rsum?