1)Display all the constraints that exist in the ToyCreator table. 2)Change the structure of the Creator table so that it
Posted: Fri Jul 08, 2022 6:36 am
1)Display all the constraints that exist in the ToyCreatortable.
2)Change the structure of the Creator table so that it cancapture the address of the creator The following columnsshould be used for capturing the address: house number, street,City, and zip code.
3)Mark the Discount column of the Toys table as unused. Verifythat the column is unused.
4)JustLee Books has recently hired a temporary salesman. Thename of the new employee is John. The login credential for Johnshould expire at the end of his contract. As a salesperson, Johnshould be granted some object privileges on the JustLee Booksdatabase:
Create the user John with a password that expire with the roleof sales_person (2 marks)
ToyCreator toylD 1001 creatorID 20100714001 1.3 Display all the constraints that exists in the ToyCreator table. (2 marks)
Creator creatorID 20100714001 ToyCreator 2 Lname Jan Fname Temba
Toys Table toyID 1001 Name F1 car Date 14-july- 2020 Cost 200 Retail 250 Discount 0 Category Cars
- 1 Display All The Constraints That Exist In The Toycreator Table 2 Change The Structure Of The Creator Table So That It 1 (220.92 KiB) Viewed 37 times
- 1 Display All The Constraints That Exist In The Toycreator Table 2 Change The Structure Of The Creator Table So That It 2 (169.89 KiB) Viewed 37 times
- 1 Display All The Constraints That Exist In The Toycreator Table 2 Change The Structure Of The Creator Table So That It 3 (141.09 KiB) Viewed 37 times
Create the user John with a password that expire with the roleof sales_person (2 marks)
ToyCreator toylD 1001 creatorID 20100714001 1.3 Display all the constraints that exists in the ToyCreator table. (2 marks)
Creator creatorID 20100714001 ToyCreator 2 Lname Jan Fname Temba
Toys Table toyID 1001 Name F1 car Date 14-july- 2020 Cost 200 Retail 250 Discount 0 Category Cars