Question: Question 3 [50 marks] 3.1 Create a table based on the Client_Data table below. The table allows the JustLee bookstore to capture client information when

 Question 3 [50 marks] 3.1 Create a table based on theClient_Data table below. The table allows the JustLee bookstore to capture client

Question 3 [50 marks] 3.1 Create a table based on the Client_Data table below. The table allows the JustLee bookstore to capture client information when buying books. Choose appropriate data types. (7 marks) Client_Data Table [Turn over] 3.2 The table that you have created does not have a primary key, make the column Member_ID the primary key of the table. (4 marks) 3.3 The column Phone number can accept null values, add a constraint to ensure that it does not allow null values. (4 marks) 3.4 Modify the Phone\# column from the current length of 10 numbers to 13 numbers. (4 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!