Provide an entity relationship diagram

Assignment Help Database Management System

Reference no: EM13803599

Your database project must meet the following assessment requirements:

Design and develop a database using professional principles and standards.

Provide a logical and physical design of the database.
Use relational database software application to develop database.
Provide an entity relationship diagram.
Normalize the database.
Generate and provide test data.

Use a Microsoft Visio diagram to normalize the ERD to third normal form (3NF).

Use the Microsoft Access database created in Week Three to create a minimum of 10 rows of test data in each table. Also, create at least one query that joins two tables and returns values from both tables.

Note. Only the Microsoft Visio diagram must be normalized to the 3NF. The 3NF is not required for a Microsoft Access database.

Write a 200- to 300-word short-answer response for the following:

In your own words, describe the nature and purpose of the normalization process. Provide some examples from sources other than the readings.

Reference no: EM13803599

Questions Cloud

Conduct a swot analysis for chosen facility : Conduct a SWOT analysis for chosen facility that examines the forces that may affect the facility.

Determine two advantages and two disadvantages of using elec : Determine two advantages and two disadvantages of using electronic recruitment resources over traditional resources. Next, identify one other method for minimizing applicants who are not qualified for available positions. Provide a rationale for you..

Supporting activity website critique : Supporting Activity Website Critique

What type of information is found on the internet : What type of information is found on the Internet? Which type of information could be of value to the community? How can members of the community be sure that the information is credible and reliable on the Internet?

Provide an entity relationship diagram : Your database project must meet the following assessment requirements: Design and develop a database using professional principles and standards. Provide a logical and physical design of the database. Use relational database software application to d..

Explain social security and medicare : Social Security and Medicare" Please respond to the following. Identify at least two changes that may occur for Social Security and Medicare benefits in the next 20 years. Then, describe key policies that the U.S. government could implement in ord..

Applying your proposed code of ethics : Parts 1 and 2 of this task took place in Week 4 and made up your Key Assignment Draft. In Part 1 of this task, you identified and described your chosen ethical issue.

Individual assignment hr focus : Individual Assignment HR Focus

Benefits of mentor program for pilots : How mentoring for pilots affects business and employment in aviation industry - Benefits of mentor program for pilots.

User Account

All Pages