Principles of Database Systems Project
This is a repository for the course project of Principles of Database Systems at New York University by Qifan Zhang, Zhen Wang, and Haoran Wang.
Part1 Objectives:
- Single PDF document with following contents:
- Cover page with clearly stated course, section, submission date, team members’ names and ids.
- A properly documented description and justification of your entire design (no more than half page), assumptions that you have made other than stated business rules, if any.
- Logical Model of database design
- Relational Model of database design
- List of tables and record counts of each table (Number of records should be 10 to 25 records in each table. Child tables should have more records than parent tables)
- DDL code (Table creation code along with PK, FK, and Check constraints)
- DML code (insert statement for all tables)
- Database trigger code that used for generating invoice
- Data Dictionary results of following queries:
-- List of Tables
select table_name
from user_tables
where table_name like 'HQZ%';
-- List of Table Columns
select table_name, column_name,column_id
from user_tab_columns
where table_name like 'HQZ%'
order by table_name,column_id;
-- List of Table Column Constraints
select table_name,constraint_name,constraint_type,search_condition,index_name,r_constraint_name,delete_rule
from user_constraints
where table_name like 'HQZ%'
order by table_name;
-- List of Table Column Comments
select table_name,column_name,comments
from user_col_comments
where table_name like 'HQZ%'
order by table_name;