HW1.docx - My database would have six table and several...

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

My database would have six table and several attributes. 1. Student_T Attribute Name Description Type Format Student_No Student NUMBER INT Number Student_First_Name Student First Name VARCHAR(20) TEXT Student_Last_Name Student Last Name VARCHAR(20) TEXT Student_Street Student Address VARCHAR(30) TEXT Student_City Student City VARCHAR(15) TEXT Student_State Student State CHAR(2) TEXT Student_Zip Student Zip INT Number Student_Phone Student Phone Number BIGINT (000) 000-0000 Student_Email Student Email VARCHAR(25) TEXT Student_Admission_Dat e Student Admission Date Date Mm/dd/yyyy 2. Faculty_T Attribute Name Description Type Format Faculty _No Faculty NUMBER INT Number Faculty _First_Name Faculty First Name VARCHAR(20) TEXT Faculty _Last_Name Faculty Last Name VARCHAR(20) TEXT Faculty _Street Faculty t Address VARCHAR(30) TEXT Faculty _City Faculty City VARCHAR(15) TEXT Faculty _State Faculty State CHAR(2) TEXT Faculty _Zip Faculty Zip

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture