Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DB2 Universal Database V7.1 Application Development Certification Guide

Authors: Steve Sanyal, David Martineau, Kevin Gashyna, Michael Kyprianou

1st Edition

0130913677, 978-0130913678

More Books

Students also viewed these Databases questions

Question

How do negotiators meet the "provisional intent test"?

Answered: 1 week ago

Question

2. How should this be dealt with by the organisation?

Answered: 1 week ago

Question

explain what is meant by the term fair dismissal

Answered: 1 week ago