Database Design

snvvkc

Assignments.docx

Home >Information Systems homework help >Database Design

1. Identify entities; These are typically the nouns and noun-phrases in the descriptive data produced in analysis.

Client Records

Stakeholders

Database

Financial Information

Rehabilitation centers

Rehabilitation team

2. Find relationships; The easiest way to see all the possible relationships is to build a table with the entities across the columns, and down the rows. Then, fill in cells to indicate where relationships exist between the entities.

	Client Records	Stakeholders	Database	Financial Information
Client Records		Are about the	Contained in
Stakeholders	make up part of the		Control and monitor the
Database	contains			contains
Financial Information		Can be viewed by	Contained in
Rehabilitation centers		Can be viewed by
Rehabilitation team		Can be viewed by

3. ERD blueprint

Financial Information

contains

Database

Rehabilitation centers

control and monitor the

Rehabilitation Crew

Client Records

Information form part of the

Stakeholders

can view

Assignment 1

· create a Logical ERD diagram with attributes (entries, columns and their relationship) based on the above Conceptual Modeling Design.

· No data types needed for the attributes yet.

I would recommend using draw.io to create your ERD. Please use crows foot notation for the relationships. Export The finished ERD as a PNG and insert the image into your docx document. Rotation of the ERD page is not an issue. If your diagram looks better in landscape mode, then use it. Cover page required for the assignment.
Model the format examples found at this website: http://www.databaseanswers.org/data_models/website_analytics/website_analytics_print_version.htm

Your checklist - Cover page, Logical ERD. Nothing else! Not even a paragraph written with APA rule 2.24 in mind.

Assignment 2

· This assignment is to be an another ERD, a physical ERD, with the data types added for each attribute.

· Please update the ERD created for Assignment 1 to include the datatypes for each attribute.

· Include the updated ERD in the new word document and name it as “ Assignemet-2”.

· Also requests that you construct the DDL (data definition language) that will build the database defined in your Physical ERD.

· You will also include DML (data manipulation language) that will populate your entities. Remember from the class that we are standardizing on the Oracle online sandbox found at https://livesql.oracle.com/.

· I will take the DDL + DML found in your paper for this week and apply it to the website and observe that it builds the database defined in your Physical ERD.

· Pay close attention to loading parent tables before the dependent tables to pick up the right key values. I will also look for proper foreign key fields and referential integrity.

Your checklist - cover page, a physical ERD and the DDL + DML to build the database from your ERD. The DDL + DML should run without error and will be executed as one script on the website.

Assignment 3

Write 200-300 words about

1. What did you accomplish this week? How has what you are learning in your current course assisted with this?

2. What did you apply and how did you apply it?

3. Were there problems encountered with job assignments or your work environment? What were your efforts towards resolution?

4. Directly connect course related content to this week’s experiences at work.