logo

Creating Tables - SQL | Doc

   

Added on  2019-10-08

12 Pages1745 Words177 Views
Part 1: ERD

Part 2: Data dictionaryTable : CITYColumn NameData TypeConstraintcityIdNUMBERPRIMARY KEYcityNameVARCHAR(50)Table : SCHOOLColumn NameData TypeConstraintschoolIdNUMBERPRIMARY KEYschoolNameVARCHAR(90)Table : ALUMNI_GROUPColumn NameData TypeConstraintgroupIdNUMBERPRIMARY KEYgroupTypeCHAR(10)CHECK (groupType in ('GRADUATES','BUSINESSES'))Table : ALUMNI_PERSONAL_DETAILSColumn NameData TypeConstraintalumniIdNUMBERPRIMARY KEYalumniNameVARCHAR(30)workContactVARCHAR(12)homeContactVARCHAR(12)emailIdVARCHAR(70)cityIdNUMBERCONSTRAINT cityId_FK FOREIGN KEY (cityId) REFERENCES CITY(cityId) ON DELETE CASCADEaddressVARCHAR(100)alumniGroupTypeIdNUMBERCONSTRAINT alumniGroupTypeId_FK FOREIGN KEY (alumniGroupTypeId) REFERENCES ALUMNI_GROUP(groupId) ONDELETE CASCADE

Table : ALUMNI_QUALIFICATIONColumn NameData TypeConstraintalumniIdNUMBERCONSTRAINT alumniId_FK FOREIGN KEY (alumniId) REFERENCES ALUMNI_PERSONAL_DETAILS(alumniId)ON DELETE CASCADEschoolIdNUMBERCONSTRAINT schoolId_FK FOREIGN KEY (schoolId) REFERENCES SCHOOL(schoolId) ON DELETE CASCADEdisciplineAreaVARCHAR(70)degreeNameVARCHAR(70)passoutYearNUMBER(4)Table : ALUMNI_JOB_DETAILSColumn NameData TypeConstraintalumniIdNUMBERCONSTRAINT alumniId_JOB_FK FOREIGN KEY (alumniId) REFERENCES ALUMNI_PERSONAL_DETAILS(alumniId)ON DELETE CASCADEcompanyNameVARCHAR(50)companyHonorVARCHAR(30)jobTitleVARHCAR(40)salaryNUMBERdojDATEendDateDATETable : ALUMNI_DONATIONSColumn NameData TypeConstraintalumniIdNUMBERCONSTRAINT alumniId_DONATIONS_FK FOREIGN KEY (alumniId) REFERENCES ALUMNI_PERSONAL_DETAILS(alumniId)ON DELETE CASCADEdonationAmountNUMBERdateeDATE

Table : ALL_ALUMNI_SUPPORTERSColumn NameData TypeConstraintalumniIdNUMBERCONSTRAINT alumniId_SUPPORTERS_FK FOREIGN KEY (alumniId) REFERENCES ALUMNI_PERSONAL_DETAILS(alumniId)ON DELETE CASCADEsupportTypeVARCHAR(70)dateeDATETable : EVENT_GUESTColumn NameData TypeConstrainteventIdNUMBERCONSTRAINT alumniId_EVENT_FK FOREIGN KEY (eventId) REFERENCES EVENT(eventId) ON DELETE CASCADEguestIdNUMBERCONSTRAINT guestId_GUEST_FK FOREIGN KEY (guestId) REFERENCES ALUMNI_PERSONAL_DETAILS(alumniId)ON DELETE CASCADEguestTypeDescVARCHAR(60)guestStatusCHAR(3)Table : EVENT_TYPEColumn NameData TypeConstrainteventTypeIdNUMBERPRIMARY KEYeventType CHAR(30)check (eventType in ('SOCIAL', 'PROFESSIONAL DEVELOPMENT'))Table : EVENTColumn NameData TypeConstrainteventIdNUMBEReventTypeIdNUMBERCONSTRAINT eventTypeId_FK FOREIGN KEY (eventTypeId)

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Schema for Event Management System
|9
|1988
|138

The Operations Rejected by the System
|7
|1034
|382

Sql Join Columns of Two Tables on Unique Key
|10
|981
|431

Assignment on Database PDF
|14
|2236
|34

Database ER Diagram
|12
|1463
|86

Assignment - Foreign Constraints | MySQL
|14
|1245
|258