Question

Consider the university database. Create a form to allow a user to view cources by department

Answer 1

Answer:

Create and Maintain a University DataBase

[AC A1]

Tables:

STUDENT(Student#, LastName, FirstName, Address, City, State, Zip, Enroll_Date, Undergrad?)

COURSE(Course#, Title, CrHour, InstName)

INSTRUCTOR(InstName, InstOffice, Rank)

Take(Student#, Course#, Grade)

1. Create the following table structures [AC 35-72]:

STUDENT [AC 179-183]

Student#

Last name

First name

Address

City

State

Zip

Enroll_Date

UnderGrad?

Text 10

Text 50

Text 50

Text 50

Text 50

Text 2

Text 10

Date/Time

Yes/No

1y Key

2y Index

> Format

Input Mask

Short Date Format

System Date Default

COURSE [AC 172-177; 185-187]

Course#

Title

CrHour

InstName

Text 10

Text 60

Byte

Lookup Wizard (INSTRUCTOR)

1y Key

Valid values: 1-4 hours

INSTRUCTOR

InstName

InstOffice

Rank

Text 50

Text 10

Text 20

1y Key

Take

Student#

Course#

Grade

Text 10

Text 10

Text 2

1y Key

1y Key

2. Create the following relationships [AC 87-93]: