تمرين 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