Question

UC State University is developing a homework database to track assignments, classes, professors, and departments (History, English, etc). Each professor, the homework database must produce their first name, middle initial, last name, title (Mrs,etc), email address, and telephone number. Each course has one professor and the homework database should save a meeting time, room number, description, and name. Each assignment has assigned date, due date, and assignment description. This homework app must also remember which course has which assignment and which professor teaches the course. For this question, please write an outline and explain the chosen primary/foreign keys, and create an Access database for all of the information in the homework app described above.

Answer 1

In the above question of University database named as HOme Database we will be creating three tables as follows

1. Proffessor details

2.Courses

3. Assignments

Wewill be naming Foreign key and Primary key on each Table as Follows:

1 Proffesor Details Table:

Fields	Datatype
ProfID(Primary Key)	Autonumber
First name	short text
Middle name	short text
Last name	short text
Title	short text
email	shorttext
Phone number	Number

2. Course Table:

Fields	Datatype
CourseId(Primary Key)	Autonumber
Course Name	short text
ProfID(Foregin Key)	Number
Meeting Time	Date/Tim,e
Room No	Number
Description	short Text

3.Assignment Table

Field	Datatype
AssignmentId(Primary Key)	Auto Number
CourseId(Foreign Key)	Number
ProffessorId(Foreign Key)	Number
Date	Date/Time
Due Date	Date/Time
Assignment Description	short text