Perform logical design on the proposed database environment

Assignment Help Database Management System

Reference no: EM131614956

Assignment: Database Design and ERD Creation

The following assignment is based on the database environment proposed in the 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.

Create a 1-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 Entity Relationship Diagram (ERD) using the data specifications from the logical design. Use Microsoft® Visio®, Lucidchart, or another software tool of your choice to create this diagram.

Attachment:- Database-Environmen-Proposal.rar

Reference no: EM131614956

Questions Cloud

Describe the community event : Describe the community event and include the survey design and plan for administering it.

Frog expend time and energy moving : Why does the frog expend time and energy moving its offspring from the place where they were "born"?

The american public regarding us involvement : Controversy existed within the American public regarding U.S. involvement.Controversy existed within the country or countries affected by U.S. involvement.

Environmental concerns that impact this system : What other common pathologies occur in this system? What are some environmental concerns that impact this system?

Perform logical design on the proposed database environment : Database Design and ERD- Creation Perform a logical design on the proposed database environment without going through the full normalization process.

Discussion you will be reflecting on the various concepts : Discussion you will be reflecting on the various concepts and principles covered throughout lesson - Use correct APA formatting rules for body of paper

Neolithic revolution on the selected civilization : Summarize the impact of the Neolithic revolution on the selected civilization. The textbook also lists and explores seven characteristics of a civilization

How fire-storm identified using curl of a vector field : A large fire becomes a fire-storm when the nearby air acquires a circulatory motion. The associated updraft has the effect of bringing more air to the fire.

Treated and prevented in the near future : How are bio chips changing the future of how cancer will be treated and prevented in the near future?

User Account

All Pages