Q1

A. Use the ER- Diagram below

a. Create a new database.

b. Name the database Registration.

c. Create and design all the tables.

d. Apply the correct Data Types and to choose the appropriate Field Size.

e. Insert demo data records into each table (minimum 8 records).

B. Views

a. Create a view that displays all the taken courses by a student with ID 915236.

b. View all classes for a specific section.

c. View all classes that have more than 15 students.

A. For each field, use the appropriate value for each one of the following Field Properties:

Required, Indexed, Null/Not Null, Default Value, Caption, Constraint

B. Create the relationships between the tables as illustrated in the Figure above.