Список сокращений.
База данных для хранения информации о студентах
FOREIGNKEY (ComendantCode) REFERENCESComendants (ComendantCode). ADDCONSTRAINTUQ_Comendants_ComendantCodeUNIQUE (ComendantCode). ALTERTABLEZaselenieStudentsADDCONSTRAINTPK_ZaselenieStudents. FOREIGNKEY (StudentCode) REFERENCESStudents (StudentCode). ADDCONSTRAINTUQ_Students_StudentCodeUNIQUE (StudentCode). ALTERTABLEZaselenieStudentsDROPCONSTRAINTFK_StudentCode. Приложение, А — Схема БД в ЕА… Читать ещё >
Список сокращений. База данных для хранения информации о студентах (реферат, курсовая, диплом, контрольная)
EA — EnterpriseArchitect.
БД — база данных СУБД — система управления базами данных.
PK — первичный ключ.
FK — вторичный ключ.
SQL — StructuredQueryLanguage (Структурированный язык запросов).
Приложения
Приложение А
Схема БД.
Приложение, А — Схема БД в ЕА.
Приложение Б
SQL код БД.
USEKursov.
;
IFEXISTS (SELECT*FROMdbo. sysobjectsWHEREid=object_id ('FK_ComendantCode') ANDOBJECTPROPERTY (id,'IsForeignKey') = 1).
ALTERTABLEObsejitiaDROPCONSTRAINTFK_ComendantCode.
;
IFEXISTS (SELECT*FROMdbo. sysobjectsWHEREid=object_id ('FK_NumberObsejitia') ANDOBJECTPROPERTY (id,'IsForeignKey') = 1).
ALTERTABLERoomsDROPCONSTRAINTFK_NumberObsejitia.
;
IFEXISTS (SELECT*FROMdbo. sysobjectsWHEREid=object_id ('FK_RoomCode') ANDOBJECTPROPERTY (id,'IsForeignKey') = 1).
ALTERTABLEZaselenieStudentsDROPCONSTRAINTFK_RoomCode.
;
IFEXISTS (SELECT*FROMdbo. sysobjectsWHEREid=object_id ('FK_StudentCode') ANDOBJECTPROPERTY (id,'IsForeignKey') = 1).
ALTERTABLEZaselenieStudentsDROPCONSTRAINTFK_StudentCode.
;
IFEXISTS (SELECT*FROMdbo. sysobjectsWHEREid=object_id ('Comendants') ANDOBJECTPROPERTY (id,'IsUserTable') = 1).
DROPTABLEComendants.
;
IFEXISTS (SELECT*FROMdbo. sysobjectsWHEREid=object_id ('Obsejitia') ANDOBJECTPROPERTY (id,'IsUserTable') = 1).
DROPTABLEObsejitia.
;
IFEXISTS (SELECT*FROMdbo. sysobjectsWHEREid=object_id ('Rooms') ANDOBJECTPROPERTY (id,'IsUserTable') = 1).
DROPTABLERooms.
;
IFEXISTS (SELECT*FROMdbo. sysobjectsWHEREid=object_id ('Students') ANDOBJECTPROPERTY (id,'IsUserTable') = 1).
DROPTABLEStudents.
;
IFEXISTS (SELECT*FROMdbo. sysobjectsWHEREid=object_id ('ZaselenieStudents') ANDOBJECTPROPERTY (id,'IsUserTable') = 1).
DROPTABLEZaselenieStudents.
;
CREATETABLEComendants (.
ComendantCodebigintNOTNULL,.
Surnamenvarchar (50) NOTNULL,.
Namenvarchar (50) NOTNULL,.
SecondNamenvarchar (50) NOTNULL,.
NmberPhonenvarchar (20) NOTNULL.
).
;
CREATETABLEObsejitia (.
NumberObsejitiabigintNOTNULL,.
Addresnvarchar (50) NOTNULL,.
ComendantCodebigintNOTNULL.
).
;
CREATETABLERooms (.
RoomCodebigintNOTNULL,.
NumberObsejitiabigintNOTNULL,.
NumberRoombigintNOTNULL,.
FloorbigintNOTNULL,.
KolvoMestbigintNOTNULL.
).
;
CREATETABLEStudents (.
StudentCodebigintNOTNULL,.
Surnamenvarchar (50) NOTNULL,.
Namenvarchar (50) NOTNULL,.
SecondNamenvarchar (50) NOTNULL,.
NumberZachetkinvarchar (40) NOTNULL,.
RoomCodebigintNOTNULL.
).
;
CREATETABLEZaselenieStudents (.
NumberZaseleniabigintNOTNULL,.
StudentCodebigintNOTNULL,.
RoomCodebigintNOTNULL.
).
;
ALTERTABLEComendants.
ADDCONSTRAINTUQ_Comendants_ComendantCodeUNIQUE (ComendantCode).
;
ALTERTABLEObsejitia.
ADDCONSTRAINTUQ_Obsejitia_NumberObsejitiaUNIQUE (NumberObsejitia).
;
ALTERTABLERooms.
ADDCONSTRAINTUQ_Rooms_RoomCodeUNIQUE (RoomCode).
;
ALTERTABLEStudents.
ADDCONSTRAINTUQ_Students_StudentCodeUNIQUE (StudentCode).
;
ALTERTABLEZaselenieStudents.
ADDCONSTRAINTUQ_ZaselenieStudents_NumberZaseleniaUNIQUE (NumberZaselenia).
;
ALTERTABLEComendantsADDCONSTRAINTPK_Comendants.
PRIMARYKEYCLUSTERED (ComendantCode).
;
ALTERTABLEObsejitiaADDCONSTRAINTPK_Obsejitia.
PRIMARYKEYCLUSTERED (NumberObsejitia).
;
ALTERTABLERoomsADDCONSTRAINTPK_Rooms.
PRIMARYKEYCLUSTERED (RoomCode).
;
ALTERTABLEStudentsADDCONSTRAINTPK_Students.
PRIMARYKEYCLUSTERED (StudentCode).
;
ALTERTABLEZaselenieStudentsADDCONSTRAINTPK_ZaselenieStudents.
PRIMARYKEYCLUSTERED (NumberZaselenia).
;
ALTERTABLEObsejitiaADDCONSTRAINTFK_ComendantCode.
FOREIGNKEY (ComendantCode) REFERENCESComendants (ComendantCode).
;
ALTERTABLERoomsADDCONSTRAINTFK_NumberObsejitia.
FOREIGNKEY (NumberObsejitia) REFERENCESObsejitia (NumberObsejitia).
;
ALTERTABLEZaselenieStudentsADDCONSTRAINTFK_RoomCode.
FOREIGNKEY (RoomCode) REFERENCESRooms (RoomCode).
;
ALTERTABLEZaselenieStudentsADDCONSTRAINTFK_StudentCode.
FOREIGNKEY (StudentCode) REFERENCESStudents (StudentCode).
;