Sql Help Please Create Text File Called Brandon Lab07txt Lab07 Directory Copy Following Te Q37204494

by
  1. MY SQL HELP PLEASE!!!!
  2. Create a text file called Brandon-Lab07.txt inyour Lab07 directory and copy the following textinto it:

    UNF:
    student(Name,HomeMobilePhoneNumbers,StudentID,MajorCode1,MajorTitle1,MajorCode2,MajorTitle2,MajorCode3,MajorTitle3)

    3NF:

    Table field meanings are:

    Three data rows:

    Do not place any extra text in the text file other than as directedin steps 3 thru 5.
    The student table field meanings are:

    • Name is the student’s full name.
    • HomeMobilePhoneNumbers is the student’s homephone number followed by the student’s mobile phone number. Not allstudents have both numbers.
    • studentID is a unique ID number assigned tothe student.
    • MajorCode1, MajorCode2, andMajorCode3 are the major codes for the student’smajors. Not all students have three majors.
    • MajorTitle1, MajorTitle2, andMajorTitle3 are the names or the student’smajors.

    Business logic:

    • Each student
      OR
      OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.