THIS ASSIGNMENT IS NEEDED IN 10 HOURS FROM NOW. SO IF YOU ASK HOW SOON DO I NEED I WILL NOT SIGN AGREEMENT BECAUSE THAT MEANS YOU REALLY DIDNT READ IT.

The following assignment is based on the database environment proposed in the Week One Individual Assignment.

Perform a logical design on the proposed database environment without going through the full normalization process.  Include the identification of all entities and attributes associated with the environment.

Use a 2-page memo to document your logical design including the process you went through.

Discuss the process you went through to select the appropriate data types, primary and foreign keys, and other constraints that are necessary to maintain the integrity of the database.

Create a detailed ERD using the data specifications from the logical design. Use Microsoft® Visio® or another tool to create this diagram. One alternative is to create a free account to access LucidChart, a Visio compaible tool (www.lucidchart.com)

Click the Assignment Files tab to submit your assignment.

In your Leaning Team this week, you built an Entity-Relationship Diagram (ERD) for Sparkle Diamonds, Inc.

For this assignment, practice your skills with creating ERDs by adding in the specification of the yellow-colored diamonds in the color scale K, L, and M, which are all classified as “faint yellow.”

Use Microsoft® Visio®, Lucidchart, or another software tool of your choice, to create this diagram.

Write a 350- to 700-word informal paper using Microsoft® Word in which you thoroughly discuss the process you went through to create your ERD, including any challenges you may have had with the software tool you used.

Submit your assignment to the Assignment Files tab.