Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started