• Liberty University

• CSIS 325

DaysofWeek DayofWeekID DayofWeek Shifts ShiftID StartTime EndTime ShiftName Patients PatientID Email CellPhone ZipCode HomePhone LastName MiddleName Referrals ReferralID StartDate EndDate PatientID PhysicianID Physicians PhysicianID FirstName SpecialtyID Email PracticeID LastName create database HCOProject create table services (ServiceID int not null, ServiceName varchar(20), constraint pk_services primary key (serviceID)) select * from services exec sp_help services create table Supplies (SupplyID int not null, SupplyDescription varchar(20), SupplyCharge numeric, constraint pk_supplies primary key (SupplyID)) select * from supplies exec sp_help supplies create table DaysofWeek (DayofWeekID int not null, DayofWeek varchar(10), constraint pk_daysofweek primary key (DayofWeekID)) select * from daysofweek exec sp_help daysofweek