Essay about IST223-GHW7FS13

2226 Words Dec 21st, 2013 9 Pages
Group Project Homework [78 pts]

Note: This assignment can become very large, due to the screen shots. Use trimming and compression to keep it at a manageable size.

Suppose that you have designed a database for Marcia's Dry Cleaning that has the following tables:
CUSTOMER (CustomerID, FirstName, LastName, Phone, Email)
ORDER (InvoiceNumber, CustomerID, DateIn, DateOut, Subtotal, Tax, TotalAmount)
ORDER_ITEM (InvoiceNumber, ItemNumber, Service, Quantity, UnitPrice, ExtendedPrice)
SERVICE (Service, Description, UnitPrice)

Add the prefix "HW7G_" to each table name.

Do parts A through M as given below. Those that involve SQL should be written in SQL*Plus and run, unless indicated otherwise.
Include screen shots of the
…show more content…
This data uses 7.90% (.079).]

InvoiceNumber
CustomerID
DateIn
DateOut
Subtotal
Tax
Total
2009001
100
10/4/2012
10/6/2012
158.50
12.52
171.02
2009002
105
10/4/2012
10/6/2012
25.00
1.98
26.98
2009003
100
10/6/2012
10/8/2012
49.00
3.87
52.87
2009004
115
10/6/2012
10/8/2012
17.50
1.38
18.88
2009005
125
10/7/2012
10/11/2012
12.00
0.95
12.95
2009006
110
10/11/2012
10/13/2012
152.50
12.05
164.55
2009007
110
10/11/2012
10/13/2012
7.00
0.55
7.55
2009008
130
10/12/2012
10/14/2012
140.50
11.10
151.60
2009009
120
10/12/2012
10/14/2012
27.00
2.13
29.13

TABLE OF ORDER ITEMS:

InvoiceNumber
ItemNumber
Service
Quantity
UnitPrice
ExtendedPrice
2009001
1
16
2
3.50
7.00
2009001
2
11
5
2.50
12.50
2009001
3
50
2
10.00
20.00
2009001
4
20
10
5.00
50.00
2009001
5
25
10
6.00
60.00
2009001
6
40
1
9.00
9.00
2009002
1
11
10
2.50
25.00
2009003
1
20
5
5.00
25.00
2009003
2
25
4
6.00
24.00
2009004
1
11
7
2.50
17.50
2009005
1
16
2
3.50
7.00
2009005
2
11
2
2.50
5.00
2009006
1
16
5
3.50
17.50
2009006
2
11
10
2.50
25.00
2009006
3
20
10
5.00
50.00
2009006
4
25
10
6.00
60.00
2009007
1
16
2
3.50
7.00
2009008
1
16
3
3.50
10.50
2009008
2
11
12
2.50
30.00
2009008
3
20
8

Related Documents