DBM 502 WEEK 3 ASSIGNMENT 2

Assignment 2

Individual: DDL and SQL Assignment

Using the model you defined in Week Two, provide the Data Definition Language (DDL) needed to create tables, attributes, primary and foreign key constraints, any other constraints needed on a single attribute or across attributes to ensure only valid data is entered, and indexes or other structures needed to make the performance adequate for the common and urgent operations.

Write the SQL code to perform each of the common and needed activities. Explain how you expect it to use the defined structures efficiently. 

Describe what tools would be available in a commonly used database to determine if the database is following the execution plan you envision.

Combine all items and submit in a 1- to 2-page APA formatted paper.

Submit your assignment using the Assignment Files tab.

Database Management

Week 2

Allen Davis

DBM/502

September 11, 2017

Database Management: Entity-Relationship Diagram

            Database Management: Third Normal Form

            There has been change in the process of normalization to a certain extent. During normalization process, it is being identified that, the purpose is to ensure that, work package is being broken down into simpler packages. The relational diagram is being complied for reflecting the basics of the position, executive name, description of position, and roles and responsibilities. There can be detailed workload by way of incorporation of the roles and responsibilities with the key segment. In case of demoralization, a visual is being available which, would be used for considering the performance of the process. The third form is bit more formalized for understanding of the requirement of the project being taken into consideration (Harper, 2013). The relational diagram has been established for potential enormity of the scope of the project and the degree of the tasks which are being carried out at a point of time.

References

Harper, R. (2013). Database Management. Routledge.