DDL and SQL Assignment help

User Generated

chxnfuryyoybaqvr

Computer Science

Description

THE DOCUMENT ATTACHED TO THIS HAS TO BE USED FOR THIS 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 urgent 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.

Unformatted Attachment Preview

Running Head: ENTITY RELATIONSHIP AND DATABASE MANAGEMENT ENTITY RELATIONSHIP DIAGRAM: DATABASE MANAGEMENT University of Phoenix DBM/502- Database Management Amanda Silva February 29th, Professor Saqib Jamshed 1 ENTITY RELATIONSHIP DIAGRAM: DATABASE MANAGEMENT Database Management: Entity-Relationship Diagram Database Management: Third Normal Form 2 ENTITY RELATIONSHIP DIAGRAM: DATABASE MANAGEMENT 3 The normalization process has changed slightly, the purpose of these was to simply breakdown the work package into smaller segments. We complied the relational diagram to reflect the basic of position, Name of executive, the positional description, and the Roles and responsibilities (PMBOK, 2008). The workload can also be more detailed by incorporating the entire roles and responsibilities within the key segment. The relationships also signifies order of operations and the responsible flow of information. As for the demoralization, perhaps now that we have a visual we may want to consider the performance of the process as we have already established the effectiveness of the organizational hierarchy. The third normal form seems a bit more streamlined in terms of understand the gravity of he project, however, the relational diagram has established the potentially enormity of the projects scope to certain degree. ENTITY RELATIONSHIP DIAGRAM: DATABASE MANAGEMENT References PMBOK. (2008). Project Quality Management. In PMBOK, A Guide to the Project Management Body of Knowledge (PMBOK GUIDE) (pp. 189,192). Newton Square, Pennsylvania: Project Management Institution. 4
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Really helped me to better understand my coursework. Super recommended.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags