Project 1 provides experience with creating ERDs and writing CREATE TABLE statements for the Expense Reporting database

Fantastic news! We've Found the answer you've been seeking!

Question:

Project 1 provides experience with creating ERDs and writing CREATE TABLE statements for the Expense Reporting database at XCorp, a fast-growing web consulting company.

You will design an ER Diagram using ER Assistant based on the table information and relationships provided in this project. In addition, you will write complete CREATE TABLE statements including column definitions, referential integrity constraints, and CHECK CONSTRAINT clauses. After creating the tables, you will insert example data and perform a few basic queries. You must have DROP statements for all database objects. The order of the DROP statements must be consistent with the dependencies among the database objects.

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–7 describe the columns in each table. Use the table and column names as shown in Tables 1–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

Contains data about expense categories in which expense items are associated

Asset

Contains data about company assets that might be associated with expense items

OrgUnit

Contains data about the organizational units in which users are members

BudgetItem

Contains data about expense budgets by organizational unit and expense category

Table 2: Columns in the Users Table

Column Name

Data Type

Comments

UserNo

Positive whole number

Primary key (should be system generated)

UserFirstName

Variable length string

Max of 50 characters; nulls not allowed

UserLastName

Variable length string

Max of 50 characters; nulls not allowed

UserPhone

Variable length string

Max of 20 characters; nulls allowed

UserEmail

Variable length character string

Max of 50 characters; unique; nulls not allowed

UserOrgNo

Positive whole number

Foreign Key to the OrgUnit table; nulls not allowed

Table 3: Columns in the ExpenseReport Table

Column

Data Type

Comments

ERNo

Positive whole number

Primary key (should be system generated)

ERDesc

Variable length string

Max of 255 characters; nulls not allowed

ERSubmitDate

Date/Time

Date and time submitted; default should be the current date and time (use a function to generate the default value); nulls not allowed

ERStatusDate

Date/Time

Date and time when the status changed; defaults to the current date and time when a record is inserted; changes when the expense report is approved or denied; use a function to generate the default value; nulls not allowed

ERStatus

Variable length string

Default value is “PENDING” meaning that the expense report is waiting for approval; this field should be limited to one of the following values “PENDING”, “APPROVED”, or “DENIED”; nulls not allowed

SubmitUserNo

Positive whole number

Foreign key to the Users table; identifies the user who submitted the expense report; nulls not allowed

ApprUserNo

Positive whole number

Foreign key to the Users table; identifies the user who approves the expense report; nulls allowed for the case of “PENDING” reports only

Table 4: Columns in the ExpenseItem Table

Column

Data Type

Comments

EINo

Positive whole number

Primary key (should be system generated)

ExpDesc

Variable length string

Max of 255 characters; nulls not allowed

ExpenseDate

Date/Time

Date and time that the expense was incurred; default should be the current date and time (use a function to generate the default value)

ExpAmt

Dollar amount

Amount of the expense; nulls not allowed; default is 0 (zero)

ExpApprAmt

Dollar amount

Approved amount of the expense; default is 0 (zero)

ERNo

Positive whole number

Foreign key to the ExpenseReport table; identifies the expense report that contains the item; nulls not allowed

ECNo

Positive whole number

Foreign key to the ExpCat table; nulls not allowed

AssetNo

Positive whole number

Foreign key to the Asset table; Nulls allowed

Table 5: Columns in the ExpCat Table

Column

Data Type

Comments

ECNo

Positive whole number

Primary key (should be system generated)

ECName

Variable length string

Max of 255 characters; nulls not allowed

ECLimit

Dollar Amount

Amount allowed per expense category expanse item; default is 0 (zero); nulls not allowed

Table 6: Columns in the Asset Table

Column

Data Type

Comments

AssetNo

Positive whole number

Primary key (should be system generated)

AssetDesc

Variable length string

Max of 255 characters; nulls not allowed

Table 7: Columns in the OrgUnit Table

Column

Data Type

Comments

OrgNo

Positive whole number

Primary key (should be system generated)

OrgName

Variable length string

Maximum length of 50 characters; nulls not allowed

OrgParentNo

Positive whole number

Refers to OrgNo; nulls allowed for the case of a parent organizational unit

Table 8: Columns in the BudgetItem Table

Column

Data Type

Comments

BINo

Positive whole number

Primary key (should be system generated)

BIYear

Number

Must be greater than or equal to 1900; default should be 2005; nulls not allowed

BIAmt

Dollar Amount

The budgeted amount for the year; nulls not allowed; default is 0 (zero)

BIActual

Dollar Amount

An ongoing sum of the actual expenses approved for the category/org unit combination in the year; default is 0 (zero)

OrgNo

Positive Whole Number

Foreign Key to the OrgUnit table; nulls not allowed

ECNo

Positive whole number

Foreign Key to the ExpCat table; nulls not allowed

Referential Integrity Constraints

Define referential integrity constraints as defined in Tables 2–7. Enforce each referential integrity constraint. For each referential integrity constraint, use a constraint name in the CREATE TABLE statement.

Choose appropriate actions when referenced rows are deleted. When an expense report is deleted, both the heading row in the ExpenseReport table and the associated detail rows in the ExpenseItem table must be deleted. For other referential integrity constraints involving required foreign keys (nulls not allowed), deleting a referenced row in a parent table must not be permitted if there are associated referencing rows in a child table. For referential integrity constraints involving optional foreign keys (nulls allowed) except ExpenseReport.ApprUserNo, deleting a referenced row must make the foreign key of the referencing row null. For ExpenseReport.ApprUserNo, restrict deletion of related User rows.

Check Constraints

Write named constraints using the CHECK CONSTRAINT clause for the following integrity constraints:

Email contains an @

ERStatusDate >= ERSubmitDate

BIYear>=1900

ERStatus is ‘PENDING’ ‘APPROVED’, or ‘DENIED’

ExpApprAmt <= ExpAmt

The combination of BIYear, OrgNo, and ECNo is unique in the BudgetItem table

Nulls are allowed for ExpenseReport.ApprUserNo only if ERStatus is equal to PENDING

Load Data

Use the text file containing INSERT statements to load the data in the tables. The text file is located in Blackboard. Note that the INSERT statements use the table and column names listed in Tables 1–7.

Deliverables

The following items must be uploaded to Blackboard upon completion of Project 1:

Screenshot of the ER Diagram while it is displayed in ER Assistant. Paste this into a Microsoft Word document. Make sure that the ERD fits on a single sheet and is legible.

Screenshots of the CREATE TABLE statements that include the appropriate constraints.

Screenshots of the INSERT statements.

Screenshots of the SQL statements and the corresponding results.

ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY HH:MI:SS';

INSERT INTO Asset
(AssetNo, AssetDesc)
VALUES (1,'Company Car');

INSERT INTO Asset
(AssetNo, AssetDesc)
VALUES (2,'Company Jet');

INSERT INTO Asset
(AssetNo, AssetDesc)
VALUES (3,'Company Van');

INSERT INTO Asset
(AssetNo, AssetDesc)
VALUES (4,'Company Truck');

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (1,'Accounting', NULL );

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (2,'Sales', NULL);

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (3,'IT', NULL);

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (4,'IT Development',3);

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (5,'Accounts Receivable',1);

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (6,'IT Support',3);

INSERT INTO OrgUnit
(OrgNo, OrgName, OrgParentNo)
VALUES (7,'Accounts Payable',1);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (1,'Dinner',50.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (2,'Car Rental',100.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (3,'Breakfast',25.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (4,'Local Transportation',100.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (5,'Airfare',5000.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (6,'Lunch',25.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (7,'Lodging',300.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (8,'Admission Fee',2000.00);

INSERT INTO ExpCat
(ECNo, ECName, ECLimit)
VALUES (9,'Gas',35.00);

INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (1,'Sue','Herdon','(206) 339-3312','sherdon@org.com',3);

INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (2,'Bill','Jones','(303) 205-8833','bjones@org.com',6);

INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (3,'Joe','Smith','(303) 443-9943','jsmith@org.com',4);

INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (4,'William','Freed','(303) 445-3355','wfreed@org.com',1);

INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (5,'Sara','Jonson','(303) 445-3321','sjonson@org.com',7);

INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (6,'Tom','Sanchez','(303) 445-3322','tsanchez@org.com',5);

INSERT INTO Users
(UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo)
VALUES (7,'Marry','Blake','(303) 445-3333','mblake@org.com',2);

INSERT INTO ExpenseReport
(ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo)
VALUES (1,'Sales Presentation','8/10/2006','8/26/2006','APPROVED',3,4);

INSERT INTO ExpenseReport
(ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo)
VALUES (2,'Conference','8/16/2006','8/17/2006','APPROVED',4,4);

INSERT INTO ExpenseReport
(ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo)
VALUES (3,'Training Course','9/23/2006','9/25/2006','APPROVED',2,1);

INSERT INTO ExpenseReport
(ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo)
VALUES (4,'IT Group Lunch','9/29/2006','9/29/2006' ,'APPROVED',1,4);

INSERT INTO ExpenseReport
(ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo)
VALUES (5,'Sales Presentation','9/30/2006','10/1/2006','APPROVED',7,4);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES (1,'Car','8/9/2006',150.00,150.00,1,7,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES (2,'Hilton','8/9/2006',99.00,99.00,1,7,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(3,'Gas','8/9/2006',35.00,20.00,1,9,1);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(4,'Breakfast','8/10/2006',10.00,10.00,1,3,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(5,'Comfort Inn','8/16/2006',225.00,225.00,2,7,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(6,'Airfare','8/13/2006',325.00,325.00,2,5,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(7,'Dinner','8/15/2006',23.94,23.94,2,1,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(8,'Dinner','8/14/2006',32.50,32.50,2,1,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(9,'Dinner','8/13/2006',19.64,19.64,2,1,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(10,'Lunch','8/15/2006',25.00,25.00,2,6,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(11,'Breakfast','8/15/2006',10.32,10.32,2,3,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(12,'Motel 6','9/23/2006',57.95,57.95,3,7,NULL);

INSERT INTO ExpenseItem
(EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo)
VALUES(13,'Gas','9/23/2006',15.94,15.94,3,9,3);

INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (1,2006,1,1,4000.00,76.08);

INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (2,2006,1,2,3000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (3,2006,1,3,2000.00,10.32);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (4,2006,1,4,500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (5,2006,1,5,10000.00,325.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (6,2006,1,6,2000.00,25.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (7,2006,1,7,10000.00,225.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (8,2006,1,8,6000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (9,2006,1,9,5000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (10,2006,2,1,10000.00,167.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (11,2006,2,2,7500.00,98.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (12,2006,2,3,4000.00,10.75);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (13,2006,2,4,1500.00,5.50);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (14,2006,2,5,15000.00,650.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (15,2006,2,6,5000.00,6.79);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (16,2006,2,7,12000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (17,2006,2,8,7500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (18,2006,2,9,7500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (19,2006,3,1,4000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (20,2006,3,2,3000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (21,2006,3,3,2000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (22,2006,3,4,500.00,24.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (23,2006,3,5,10000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (24,2006,3,6,2000.00,75.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (25,2006,3,7,10000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (26,2006,3,8,10000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (27,2006,3,9,5000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (28,2006,4,1,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (29,2006,4,2,1200.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (30,2006,4,3,1000.00,10.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (31,2006,4,4,250.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (32,2006,4,5,4000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (33,2006,4,6,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (34,2006,4,7,2000.00,99.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (35,2006,4,8,8000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (36,2006,4,9,650.00,35.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (37,2006,5,1,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (38,2006,5,2,1200.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (39,2006,5,3,1000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (40,2006,5,4,250.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (41,2006,5,5,4000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (42,2006,5,6,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (43,2006,5,7,2000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (44,2006,5,8,5500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (45,2006,5,9,350.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (46,2006,6,1,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (47,2006,6,2,1200.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (48,2006,6,3,1000.00,2.99);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (49,2006,6,4,250.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (50,2006,6,5,4000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (51,2006,6,6,1500.00,5.95);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (52,2006,6,7,2000.00,57.95);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (53,2006,6,8,5500.00,1000.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (54,2006,6,9,350.00,15.94);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (55,2006,7,1,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (56,2006,7,2,1200.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (57,2006,7,3,1000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (58,2006,7,4,250.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (59,2006,7,5,4000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (60,2006,7,6,1500.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (61,2006,7,7,2000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (62,2006,7,8,8000.00,0.00);
INSERT INTO BudgetItem
(BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual)
VALUES (63,2006,7,9,650.00,0.00);

DROP SEQUENCE expenseitem_seq;
DROP SEQUENCE expensereport_seq;
DROP SEQUENCE users_seq;
DROP SEQUENCE asset_seq;
DROP SEQUENCE orgunit_seq;
DROP SEQUENCE expcat_seq;
DROP SEQUENCE budgetitem_seq;

CREATE SEQUENCE asset_seq START WITH 100 INCREMENT BY 1;
CREATE SEQUENCE orgunit_seq START WITH 100 INCREMENT BY 1;
CREATE SEQUENCE expcat_seq START WITH 100 INCREMENT BY 1;
CREATE SEQUENCE users_seq START WITH 100 INCREMENT BY 1;
CREATE SEQUENCE expensereport_seq START WITH 100 INCREMENT BY 1;
CREATE SEQUENCE expenseitem_seq START WITH 100 INCREMENT BY 1;
CREATE SEQUENCE budgetitem_seq START WITH 100 INCREMENT BY 1;