DBM 502 WEEK 3 DDL and SQL
Assignment
DBM 502
WEEK 3 DDL and SQL Assignment
DBM 502 WEEK
3 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 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.
Submit your assignment.
V020119
DBM 502 WEEK 3 DDL and SQL
Assignment
Комментарии
Отправить комментарий