1)Display all the constraints that exist in the ToyCreatortable.
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 36 times
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.
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 36 times
3)Mark the Discount column of the Toys table as unused. Verifythat the column is unused.
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 36 times
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!