تمرين CPCS241
|
A-Write a SQL statement to create a table customers including columns customer_id, first_name , last_name ,city , Birth_Date and customer_phon.
B-Design the table such that
1-Customer’s first name cannot be empty.
2-Select the appropriate column as a primary key
C-Insert the following information into the table :
customer_id
|
first_name
|
last_name
|
city
|
Birth_Date
|
customer_phone
|
159
|
Amani
|
Al-harbi
|
Mecca
|
5-2-1990
|
0587963857
|
158
|
Huda
|
Nader
|
Jeddah
|
8-7-1985
|
0558899944
|
|
آخر تحديث
4/22/2019 4:39:58 AM
|
|
|