HW3.docx - I used MySql work bench to complete my data...

This preview shows page 1 - 3 out of 3 pages.

I used MySql work bench to complete my data dictionary and ER diagram.My database would have six table and several attributes.1.Student_TAttribute NameDescriptionTypeFormatPK/FKRangeStudent_NoStudentNUMBERINTNumberPKAuto-numberStudent_First_NameStudent FirstNameVARCHAR(20)TEXT20 charStudent_Last_NameStudent LastNameVARCHAR(20)TEXT20 charStudent_Street_AddressStudent AddressVARCHAR(30)TEXT30 charStudent_CityStudent CityVARCHAR(15)TEXT15 charStudent_StateStudent StateCHAR(2)TEXT2 charStudent_ZipStudent ZipINTNumber6-10digitsStudent_PhoneStudent PhoneNumberBIGINT(000) 000-0000NAStudent_EmailStudent EmailVARCHAR(45)TEXT45 charStudent_Admission_DateStudentAdmission DateDateMm/dd/yyyyNA2.Faculty_TAttribute NameDescriptionTypeFormatPK/FKRangeFaculty _NoFacultyINTNumberPKAuto-
NUMBERNumberFaculty _First_NameFacultyFirst NameVARCHAR(20)TEXT20 charFaculty _Last_NameFaculty LastNameVARCHAR(20)TEXT20 charFaculty _Street_AddressFaculty

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture