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.
Database application - Define database elements: field, record, table
crt 205 - The Opposing Viewpoints Resource Center database at the University ...
Database Essentials - 2 questions. what is the importance of databases in ...
crj216 - Define database and explain how you could use a simple database (like ...
computer science - I need a realational database containing information about ...
Database Decision - When deciding whether to store data in a database or in a ...
math - a database with an availibility of 93.4% is accessed via a network with ...
Database - Can some help me produce a sample of Gas Station database that is ...
IT Information Systems Technology - Why are database management systems ...
finance - Your company will generate $45,000 in cash flow each year for the next...