Một Số Bài Tập Về Tạo View Trong SQL - Đề Thi Aptech

• Home
• SQL
  • Hệ Quản Trị CSDL
• C#
  • Window Form (WFC)
• ORTHER
  • Lập Trình Shell

• Trang chủ
• Chia sẽ kiến thức
• Một số bài tập về tạo View trong SQL

Một số bài tập về tạo View trong SQL

Sau đây là một số bài tập yêu cầu tạo View trong sql từ đễ đến phức tạp cho các bạn tham khảo

--a. Create a view named cus_rental_vw based on information from Customer and Rental table. The information that is to be included in the view is given below: CNo, CName, Property_No, RentStart, RentFinish Create view cus_rental_vw as select C.CNo, CName, Property_No, RentStart, RentFinish from Customer C, Rental R where C.CNo = R.CNo --b. Display all the record in the above view. Display only the top 3 record in the view alphabetically sorted by Customer name. select * from cus_rental_vw select top 3 * from cus_rental_vw order by CName DESC --c. Change the view such as that the Property_No is no longer visible in the view alter view cus_rental_vw as select C.CNo, CName, RentStart, RentFinish from Customer C, Rental R where C.CNo = R.CNo --d. Finally, assuming that the view is not proving useful and many managers have not used it. Write the statements to remove the view. drop view cus_rental_vw   --e. Create an index view named IX_Propertyinfo on the view which will contain PropertyNo, PAddress, Rentprice, OwnerNo column of Property table. Using appropriate option this view. create view Propertyinfo_vv with schemabinding as select Property_No, PAddress, Rentprice, OwnerNo from dbo.Property create unique clustered index IX_Propertyinfo on Propertyinfo_vv(Property_No) --f. Create view named Property_Report_vw to report that how many properties which each customer has rented over ten months? CNo, Cname, number of months create view Property_Report_vw as select C.CNo, CName, COUNT0 as "Number of Property" from Customer C, Rental R where R.CNo = C.CNo and DATEDIFF(MM, RentStart, RentFinish)>10 group by C.CNo, CName --g. Create view named property_vw, display all properties which have rent price over 300. The view will need to check for domain integrity by using ‘WITH CHECK OPTION’ option. create view property_vw as select * from Property where RentPrice>300 with check option --h. Modifying product_vw view the following: * Inserting a property into view with rent price is 370 with the following information: 'P011', '15 Chau Van Liem street, 2 dist, HCM city', 370, 'W002' * Update rent price of the property with id 'P011' into 250. insert into property_vw values('P011', '15 Chau Van Liem street, 2 dist, HCM city', 370, 'W002' ) sp_helptext Property_Report_vw Tập tin đính kèm gồm: + Code tạo bảng và chèn dữ liệu sẵn + File PDF đề bài yêu cầu + File code đáp án Download Here

Đề Thi Aptech

• Aptech Examination - Sem 3
• Aptech Examination - Sem 4

Chia Sẽ Kiến Thức

• Hệ Quản Trị CSDL (SSDO)
• Window Form (WFC)
• Lập Trình Shell

Châu Thái Nhân | Can Tho University Software Center | Email: [email protected] | Phone: 01695166587 Copyright © 2015 DeThiAptech.Wap.Sh --- Truy cập: 1/1/60441 Loading ... pacman, rainbows, and rol»