DBMS$-2006$ Final Project Milestone One Project Proposal

Developer Name:

Project Name:

Date:

$1.$ Project description:

$[$write one or two paragraphs about the project, what it will do$,$ etc$]$

$[$Explain why you chose this project$]$

$2.$ Business Case

$[$Write one or two paragraphs describing why this project is needed, who is the target audience$]$

$3.$ Business Rules$/$Assumptions

$[$ Make a list of business rules for the project, remember to think in both directions examples: A resident can visit zero to many tourist sites.

A tourist site may have zero to many residents visiting.

A resident may visit a tourist site one to many times.

$]$

$4.$ Entity Relationship Diagram

$[$ Using a diagramming tool of your choice, create the ERD diagram. Be sure to include meaningful field names and that your PK$$s and FK$$s identified. Remember every table needs a primary key and every relationship line needs a verb describing the relationship line. Paste a screenshot below.

When you review the ERD with your instructor you will be asked the following. Open the ERD in the program you created it in$.$

$$ Describe each entity and how they relate to each other in both directions

$$ Describe the symbols used on each line

$$ If there were any bridge or joiner tables created

$$ Explain why the table was created

$$ Explain what PK was created for the joiner$/$bridge table and what makes it a good primary key

$$ Explain FK$$s in the bridge table and their purpose

$]$

NOTE: Students are not permitted to have a project based on an academic environment $($students$,$ courses, books, instructors....$).$ Project must be unique an