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.
Answer this Question
it 210 computer programming - I need to generate an object oriented design for a...
crj216 - Define database and explain how you could use a simple database (like ...
Grades - I need some help on calculating my current high school GPA. So far, I'...
Statistics - A planner wants to determine the percentage of students who will ...
math - There are 37 accounting classes with 26 students in each class. Estimate ...
essay cont. to Mrs. Sue - I disagree with Petreís view that colleges donít help ...
Access Database - computers - I have to make a database to track university ...
math - 4. Gregory teaches martial arts. He charges a one-time processing fee of...
math - For every girl taking classes at a Martin martial arts school there are 3...
math - For every girl taking classes at the martial arts school, there are 3 ...