Design question You have been asked to design a database for a University. Three tables are required. Faculty, Students, Courses. List the structure for each table. Use the notation that I have listed below under For each table identify and list 5 attributes and list the data type for each attribute. For each table identify Primary Key and Foreign Key. Describe the relationship between these tables. Show sample records for each table. The following are business rules: Students can take many courses. Faculty can teach many courses. Each student is assigned a faulty as advisor. Note: To show the structure for each table you must use the following notation: Your answer must be similar to the following: Table_Name ( Primary Key, Attribute1, Attribute2, Attribute3, Attribute4, Attribute5, foreignKey) Following is an example of how you should list the structure for each table. Let’s say you want to show the structure for a Customer Table. Following is how to write the structure for Customer table and Sample record. Your answer for table Faculty, Course, Student must be similar to the following: Customer table structure Customer ( Cistomer_ID, lastName, firstName, Phone, Email, repId) Data type: customerId numeric lastName string firstName string phone string email string repId numeric Sample record Customer ( 442321, Anderson, John, 703-456-1123, andy@gmail.com, 77623)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Design question

You have been asked to design a database for a University. Three tables are required. Faculty, Students, Courses.

List the structure for each table. Use the notation that I have listed below under
For each table identify and list 5 attributes and list the data type for each attribute.
For each table identify Primary Key and Foreign Key.
Describe the relationship between these tables.
Show sample records for each table.

The following are business rules:

Students can take many courses.

Faculty can teach many courses.

Each student is assigned a faulty as advisor.

Note: To show the structure for each table you must use the following notation: Your answer must be similar to the following:

Table_Name ( Primary Key, Attribute1, Attribute2, Attribute3, Attribute4, Attribute5, foreignKey)

Following is an example of how you should list the structure for each table.

Let’s say you want to show the structure for a Customer Table. Following is how to write the structure for Customer table and Sample record.

Your answer for table Faculty, Course, Student must be similar to the following:

Customer table structure

Customer ( Cistomer_ID, lastName, firstName, Phone, Email, repId)

Data type:

customerId numeric

lastName string

firstName string

phone string

email string

repId numeric

Sample record

Customer ( 442321, Anderson, John, 703-456-1123, andy@gmail.com, 77623)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions