CSIS 325 Semester Project Phase Instructions
Phase II is performed in three steps.
Step 1: Table Creaon
Create a new database and execute the code below in SQL Server’s query window to create the database tables.
CREATETABLEPhysicianSpecialties
(SpecialtyIDinteger,
SpecialtyName 50varchar( ),
CONSTRAINTPK_PhysicianSpecialtiesPRIMARYKEY (SpecialtyID))
go
CREATETABLEZipCodes
( ( ),ZipCodevarchar 10
City varchar( ),50
Statevarchar( ),2
CONSTRAINTPK_ZipCodesPRIMARYKEY (ZipCode))
go
CREATETABLEPhysicianPractices
(PracticeIDinteger,
PracticeName 50varchar( ),
Address_Line1 varchar( ),50
Address_Line2 varchar( ),50
ZipCode 10varchar( ),
Phone varchar( ),14
Fax varchar(14),
WebsiteURL 50varchar( ),
CONSTRAINTPK_PhysicianPracticesPRIMARYKEY ( ),PracticeID
CONSTRAINTFK_PhysicianPractices_ZipCodesFOREIGNKEY ( )ZipCode REFERENCESZipcodes)
go
CREATETABLE Physicians
(PhysicianIDinteger,
FirstName varchar( ),40
LastName 50varchar( ),
PracticeIDinteger,
SpecialtyIDinteger,
Email varchar( ),50
CONSTRAINTPK_PhysiciansPRIMARYKEY ( ),PhysicianID
CONSTRAINT REFERENCESFK_Physicians_PracticesFOREIGNKEY ( )PracticeID PhysicianPractices,
CONSTRAINTFK_Physicians_PhysicianSpecialitiesFOREIGNKEY
(SpecialtyID)REFERENCESPhysicianSpecialties)
go
