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 the](https://s3.amazonaws.com/si.experts.images/answers/2024/09/66dcde0f253b8_79866dcde0eb0fbb.jpg)

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
Get step-by-step solutions from verified subject matter experts
