Marcia 세탁소
- 최초 등록일
- 2012.03.23
- 최종 저작일
- 2011.12
- 59페이지/ MS 파워포인트
- 가격 2,000원
소개글
데이터베이스 연습문제 입니다. Marcia세탁소 연습문제 입니다. A+받았던 과제입니다.
목차
테이블 생성(CREAT TABLE)
데이터 입력(INSERT)
UPDATE 문
DELETE 문
OrderSummaryView
CustomerOrderSummaryView
CustomerOrderHistoryView
CustomerOrderCheckView
Design Trigger
Answer & Questions
본문내용
CustomerOrderSummaryView
CREATE VIEW CustomerOrderSummaryView AS
SELECT O.InvoiceNumber, C.FirstName, C.LastName, C.Phone,
O.DateIn, O.DateOut, O.Subtotal,
OI.ItemNumber, OI.[Service], OI.ExtendedPrice
FROM CUSTOMER AS C, [ORDER] AS O, ORDER_ITEM AS OI
WHERE C.CustomerID = O.CustomerID
AND O.InvoiceNumber = OI.InvoiceNumber
K.
VI. CustomerOrderSummaryView
CustomerOrderSummaryView
VII. CustomerOrderHistoryView
CustomerOrderHistoryView
CREATE VIEW CustomerOrderHistoryView AS
SELECT O.InvoiceNumber, C.FirstName, C.LastName, C.Phone,
O.DateIn, O.DateOut, O.Subtotal,
OI.ExtendedPrice,
SUM (OI.ExtendedPrice) AS TotalExtendedPrice,
AVG (OI.ExtendedPrice) AS AverageExtendedPrice
FROM CUSTOMER AS C, [ORDER] AS O, ORDER_ITEM AS OI
WHERE C.CustomerID = O.CustomerID
AND O.InvoiceNumber = OI.InvoiceNumber
GROUP BY C. LastName, C. FirstName, O.InvoiceNumber,
C.Phone, O.DateIn, O.DateOut, O.Subtotal,
참고 자료
없음