Posted by Anonymous on .
University XYZ needs a database that keeps track of students, what classes they taken and the grades for each of the classes. In addition, they need to know what instructors are on staff and the courses they are approved to teach. It is necessary to track rooms for each campus including capacities as well as special facilities for each room.
Review the solution .pdf file in Doc Sharing, and Adjust your ERD in Visio to look like this one.
This project is due in Week 4 and is worth 75 points.
Now we will convert our conceptual model into a logical model. Using Microsoft Access, perform the following steps.
For each entity listed in the Solution file, create a table in Access.
Add primary keys for each table.
Set column properties for unique constraints.
Update the datatype for the attributes to enforce the domain constraints of the data.
Dates should have a date datatype.
Surrogate keys should be autonumber.
Numeric should have a numeric datatype.
Character data should have a character datatype.
Under Database Tools, create the relationships, as appropriate.
(All relationships should have referential integrity and the cascade update enabled.)
Add several rows of data for each table.
Add column constraints, as indicated.
Campus name should be ONLINE or the campus name.
Student name shall be not null.
Course credit hours must be between 1 and 4.
Course name must be unique and not null.
Instructor last name and first name should not be null.
Grade should be one of these values: A, B, C, D, F, I, W, or E (Enrolled).
If you need help, you could post the suggested table names and the data each table contains.
Remember this is an occasion to practise what you have learned in your course, and you will need this knowledge / competence to pass your exam, and eventually solve a customer's problem during your career.