assignment 2

ACCT-361: Database Project Step Two (20 points)

Due date: 10/26 11.59pm

Instructions: 1. If you are given feedback to change things in Step 1, make sure you follow it. If you

are not given any feedback, it means everything is good as is. The feedback is on Blackboard, under Project Step 1. In most cases you can increase your Step 1 grade if

you reupload. You may upload corrected versions of Step 1 until Step 2 due date. One thing to note is that I will regrade your Step 1 only once. So, make sure you

understand the feedback you are given. I will regrade Step 1 when grading Step 2. Also, you can upload multiple versions of your project steps. I will always grade the

latest one at the time of grading. Therefore, you do not need to ask me to grade the updated version.

2. Begin to build your system project prototype using the two chosen events (needs to be connected, as per Step 1 instructions) and related resources and agents from your

Step 1.

3. Create the tables with primary key, foreign keys and non-keys based on rules we have used for implementation in this course. Grading of this assignment is based heavily on

proper implementation. Selection of non-key attributes based on your chosen industry is also critical. If I recognize your effort in doing so, you will be rewarded.

4. Create the relationships between tables and enforce referential integrity. (Remember for Step 2 and your project that only prototype (implement in Access) 2 events

selected in Step 1 along with related master files and linking tables, not the entire process.) Enforcing referential integrity is quite simple – when you double-click on the

relationship line, you should see a checkbox about it. Relationships can be implemented and reviewed by clicking Database Tools/Relationships in Access.

5. Make sure to choose the correct data type when building fields in tables. This step is a

good time to consider using unique industry attributes and auto number data type. Review of these topics can be found in the Tables lab videos on Blackboard, under

Course Resources, Microsoft Access Help Resources, Tables Lab and Videos.

6. Do not populate tables with data at this point.

7. Keep your graded step 1 & 2 as you will need that for the final project.

8. Save your database as: YourLastName_FirstName_Spring20_ FirmName

What to submit: 1. PAPER: A print screen of your relationships created in the database – with referential

integrity enforced. Expand print screen size, if too small.

2. UPLOAD TO BLACKBOARD: Access Database File.

3. UPLOAD TO BLACKBOARD: Data dictionary for all tables. This can be accessed in MS Access under Tools/Documenter. See next page for data dictionary instructions.

Steps to save data dictionary as .pdf for all tables for Project Step 2: 1. Select Database Tools tab. Click Database Documenter icon. 2. Documenter window pops up. Select all table names. Click Options button. 3. Print Table Definition window pops up. There are three sections: Tables, Fields, Indexes:

a. For Tables – Include Properties and Relationships. b. For Fields – Select Names, Data Types and Sizes only. c. For Indexes- Select Nothing.

4. Click OK. Click PDF or XPS. 5. Save in PDF format and upload to blackboard.