Solution-Create a database design specification

Create a database design specification

Assignment Help Database Management System

Reference no: EM13324613

Create a database design specification (Enhanced Entity Relationship Diagram (EERD) and Relational Data Model (RDM)) from the given business description. The RDM must be in 3rd Normal Form.

The following defines the minimum information that should be reported:

• List and explain the defined business rules that can be determined from the business description.

• The Enhanced Entity Relationship Diagram (EERD) produced with a drawing or case tool. Your EERD must use a 'standard' notation style such as Crows Foot or Chen. Please note that the relationship diagram produced using MS Access, or MS SQL Server is NOT an acceptable ERD notation. Your EERD must show:

o All entities,
o Primary and Foreign keys, as appropriate,
o All attributes for each entity,
o Relationships between entities, including their cardinality and optionality,
o The EERD must not contain any M:N relationships. These must be decomposed.

• The Relational Data Model (RDM) which corresponds to the ERD in the format shown below. The RDM MUST identify all primary keys, alternate keys and foreign key constraints. Raw SQL Create Table script dumps from a modeling tool, or SQL Server WILL NOT be accepted.

• The RDM must be in 3rd Normal Form.

• The assumptions that you have made to develop the system.

Reference no: EM13324613

Questions Cloud

Determine how high does the rocket go : A model rocket is fired upward. The rocket's average initial acceleration is 40.5 m/s2 until the fuel burns out in 0.805 s. How high does the rocket go

Explain the amount of kmno4 delivered to the solution : The stock solution of KMnO_4 has a concentration of 2.6 X 10 ^ -4M. The pipette has a volume of 10.0mL. What is the amount of KMnO_4 delivered to the solution, in moles

How many electrons are transferred between you and the cat : If a cat repeatedly rubs against your cotton slacks on a dry day, the charge transfer between the cat hair and the cotton can leave you with an excess charge of -2.00 ?C. How many electrons are transferred between you and the cat

Explain what quantity of fe^2+ added to the beaker of mno : The movie has been moved to the position where about half of the F^2+ solution has been added. At this stage, what quantity of Fe^2+, in moles have been added to the beaker for each mole of MnO

Create a database design specification : The Enhanced Entity Relationship Diagram (EERD) produced with a drawing or case tool. Your EERD must use a 'standard' notation style such as Crows Foot or Chen.

Procedures or requirements for the expenditure cycle : Listed below are 12 internal control procedures or requirements for the expenditure cycle (purchasing, payroll, accounts payable, and cash disbursements) of a manufacturing enterprise. For each of the following, identify the error or misstatem..

Calculate the magnitude of the electrostatic force : A particle of charge +2.56 x 10-6 C is 12.4 cm distant from a second particle of charge -1.55 x 10-6 C. Calculate the magnitude of the electrostatic force between the particles

The data must be gathered from authoritative and scholarly : I must Gather data to answer the above from multiple sources and present that data in one to two pages (12-point font, double-spaced). Be sure to document your sources. The data must be gathered from authoritative and scholarly sources.

Develop a prototype of your proposede-commerce website : List and briefly describe any links and resources that you have used or are likely to use to research and build your e-commerce website.

User Account

All Pages

Create a database design specification

Reference no: EM13324613

Reference no: EM13324613

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT