26saoipaulo@gmail.com STEP 1- Review the ERD below to understand the entities, a

Question

26saoipaulo@gmail.com

STEP 1-   Review the ERD below to understand the entities, attributes, primary keys, and relationships that you will create in your Access database.    

See the tutorials above for instructions on how to perform the following steps in Access 2010.       

Add tables to the Access database.    

  For every column in every table, update the data type as needed to enforce the domain constraints of the data.    

Draw relationships between your entities.    

Add at least two rows of data to each table in your database. Use any values you like for each of the columns. Remember that you must add data to parent tables before adding data to child tables, because referential integrity is enabled.    

Set the following column constraints in your database.    

When you are done, save the file on your local hard drive and upload it to the Week 5 Course Project Dropbox. Your file should have the following filename format: Lab3_FirstInitialLastName.accdb.    

For instructions on how to copy files between the Citrix server and your local machine, watch the iLab tutorial, Copying Files from Citrix, located in the iLab menu tab under Course Home.    

Submit your assignment to the Dropbox located on the silver tab at the top of this page.    

(See the Syllabus section "Due Dates for Assignments & Exams" for due date information.)    

You have 2 weeks to complete this assignment. See the Syllabus section "Due Dates for Assignments & Exams" for due date information.    

Points will be awarded according to the following rubrics.    

  This assignment is subject to the late policy outlined in the Syllabus.

HERE IS BLANK DATABASE FROM WHICH YOU CREATE EVERYTHING

Explanation / Answer

The entities and their attributes

1. STUDENT

2. CAMPUS

3. ROOM

4. INSTRUCTOR

5. COURSE

6. APPROVEDINSTRUCTOR

7. CLASS

8. STUDENTGRADE

THE COLUMN CONSTRAINTS ARE

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.