DBST 651 Project 1- Design and Implement a Database

DBST 651 University of Maryland Global GrandMed Hospital Statement of Work HW

Project 1: Design and Implement a Database of your choice

Print

You will design and implement a database of your choice. See Learning Demonstration posted under Course Content/Hands-on Resources for step-by-steop instructions.

Project 1 is divided into four steps -  

• Step #1 - Write a 1-2 page Statement of Work (SOW) to describe the need to create, design and implement the database that you propose for your project.
• Step #2 - Create requirement definition document and use ER Assistant, Visio, or SQL Developer Data Modeler to create Entity Relationship Diagram (ERD) for your project.
• Step #3 - Use SQL DDL statements to create your tables/views/triggers and other required database objects for you project. Also include queries (select statements on database catalog/data dictionary such as user_objects and user_tables) to demonstrate all objects are created successfully.
• Step #4 - Use SQL DML statements to insert sample data into your tables. Use SQL SELECT statements to query your data. This submission should be a final technical report which includes Project Step #1, Step #2, Step #3, Step #4 and follow the technical report template.