Assingment for a Database

1843 Words8 Pages
Assignment Advanced Database Management Systems Database Design and Application. Due Date: 1-5-2013 (Flexible) This Assignment involves writing CREATE TABLE statements for the Expense Reporting database at XCorp, a fast growing Web consulting company. You need to write complete CREATE TABLE statements including column definitions, referential integrity constraints, and CHECK CONSTRAINT clauses. In addition you must also create a number of views. It is possible for you to use either MySQL or Oracle to complete your assignment. Associated with this assignment are a number of scripts that contain the data to populate the tables. These scripts may need to be cleaned by you so that they may work for the database of your choice. You will need to submit the scripts, along with screen shots of the work that you have done as part of a comprehensive submission. You may work in groups of no larger than 3 persons to complete this assignment. 1. Table Descriptions The Expense Reporting database contains tables to track users and expense reports (heading and detail data) along with support tables to track expense categories, status codes, and limits on expense category spending. Table 1 briefly summarizes the meaning of each table. Tables 2 to 7 describe the columns in each table. You should use the table and column names as shown in Tables 1 to 7. Choose the appropriate data type for each column. Table 1: Tables in the Expense Reports Database |Table Name |Description | |Users |Contains data about users who can submit expense reports | |ExpenseReport |Contains data on the headings of expense reports | |ExpenseItem |Contains data on the detail lines of expense reports | |ExpCat

More about Assingment for a Database

Open Document