Ayan Hassan Maria Iqbal Shyri Khanzada Syed Fahad Asif Ali Abdullah Memon yai lo sab ab mai agr kal nahi aon to meri leave dy dyna Sir ko yad say :( --Create Database-- Create Database SaintClaraServices --Create table 1-- Create table CustomerDetails ( ClientID int primary key, FatherName Char, MotherName Char, Amount Money, Period int, [Plan] Char, Premium Money, NomineeName Char, Date DateTime ) --Create table 2-- Create table CustomerHeader ( ClientID int primary key, FirstName Char, LastName Char, MiddleName Char, Gender Char, DateOfBirth Datetime, Adress Varchar(max), MaritalStatus Char, Age int, Employment char, CompanyName varchar(max), CompanyAddress varchar(max) ) --add foreign key to CustomerDetail alter table CustomerDetails add constraint fk_Clients foreign key (ClientID) references CustomerHeader(ClientID) --add Gerder Check and Default Values alter table CustomerHeader add constraint ck_Gender check (gender = M or gender= F) alter table CustomerHeader add constraint ck_MaritalStatus default Single for MaritalStatus --add Age Verifying alter table CustomerHeader add constraint ck_Age check (Age>=21) INSERT INTO CustomerHeader (FirstName, LastName, MiddleName, Gender, DateOfBirth, Adress, MaritalStatus, Age, Employment) VALUES (kashif,khan,raza,M,2/26/1991,latifabaf,Single,22,Student); SELECT * FROM CustomerHeader DELETE FROM CustomerHeader SELECT * FROM CustomerDetails
Posted on: Fri, 22 Nov 2013 01:10:29 +0000
Trending Topics
Recently Viewed Topics
© 2015