(Solved): 1)Display all the constraints that exist in the ToyCreator table.   2)Change the structure of ...

1)Display all the constraints that exist in the ToyCreator table.

 

2)Change the structure of the Creator table so that it can capture the address of the creator The following columns should be used for capturing the address: house number, street, City, and zip code.

 

3)Mark the Discount column of the Toys table as unused. Verify that the column is unused.

4)JustLee Books has recently hired a temporary salesman. The name of the new employee is John. The login credential for John should expire at the end of his contract. As a salesperson, John should be granted some object privileges on the JustLee Books database:

Create the user John with a password that expire with the role of 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