• Has to be done on visual paradigm
• Phase 2 | ERD | Conceptual, Logical, Physical

DELIVERABLES:

• Submit Visual Paradigm Project - Tiny_College.vpp
• Submit
  • conceptual_erd.pdf
  • logical_erd.pdf
  • physical_erd.pdf
• Conceptual -
  • entity color = green
  • No Primary or Foreign Keys
  • No Data Types
  • Do Not split composite attributes
  • Multivalued attribute remains as an attribute
  • Do Not represent M:N relationship as an entity
  • Make the following changes to the following Primary Keys:
    • emp_num -> emp_id
    • school_code -> school_id
    • dept_code -> dept_id
    • crs_code -> crs_id
    • class_code -> class_id
    • stu_num -> stu_id
    • room_code -> room_id
    • bldg_code -> bldg_id
• Logical -
  • entity color = light orange
  • specify Primary Keys
  • Primary keys are 1st attribute
  • Foreign keys are last attributes
  • split composite attributes
  • specify attribute data types
  • represent multivalued attributes as entities
  • Do Not represent M:N relationship as entity
  • Sync to Physical
• Physical
  • entity color = darker orange
  • Bridge entity is created for M:N relationship
  • Add any attributes that belong to relationship to Bridge entity
• Project Presentation
  • The ERD layouts must be perfect - refer to provided examples from HW solutions
  • Entities well spaced to provide room for relationship names to be clearly understandable
  • Relationship lines are either VERTICAL or HORIZONTAL
  • Change of Direction of relationship line is at 90 degrees
  • Cardinality & Participation must be clear
  • Relationship lines DO NOT connect to entity corners
  • Relationship lines DO NOT cross over
  • Font size = 14
  • Relationship line thickness = 3px
• *I CAN POST THEM OVER SEVERAL QUESTIONS*

8. Each department has several students whose major is offered by that department. However, each student has only a single major and is, therefore, associated with a single department. Draw the ERD for requirement 8 FIGURE 4.44 THE SEVENTH TINY COLLEGE ERD SEGMENT STUDENT STU NUM DEPARTMENT PK DEPT CODE DEPT_NAME -has PK FK1 DEPT CODE STU_LNAME STU FNAME STU INITIAL STUE_MAIL 9. Each student has an advisor in his or her department; each advisor counsels several students. An advisor is also a professor Draw the ERD for requirement 9 FIGURE 4.45 THE EIGHTH TINY COLLEGE ERD SEGMENT EMPLOYEE PK EMP NUM + a Isia EMP LNAME EMP_FNAME EMP INITIAL EMP EMAIL PROFESSOR STUDENT PK,FK1 EMP NUM PK STU NUM Ot! 4 - advises - PROF SPECIALTY STULNAME PROF RANK STUFNAME STU INITIAL STUE_MAIL FK1 EMPNUM 10. A CLASS is held in a ROOM. Each ROOM is located in a BUILDING. A BUILDING can contain many ROOMS, but each ROOM is found in a single BUILDING. Some BUILDINGS do not contain (CLASS] rooms. FIGURE 4.46 THE NINTH TINY COLLEGE ERD SEGMENT BUILDING ROOM CLASS PK BLDG CODE PK ROOM CODE PK - - contains - - CLASS CODE Lit is usedia od BLDG_NAME FK1 BLDG_CODE FK1 ROOM_CODE BLDG LOCATION ROOM_TYPE CLASS_TIME 8. Each department has several students whose major is offered by that department. However, each student has only a single major and is, therefore, associated with a single department. Draw the ERD for requirement 8 FIGURE 4.44 THE SEVENTH TINY COLLEGE ERD SEGMENT STUDENT STU NUM DEPARTMENT PK DEPT CODE DEPT_NAME -has PK FK1 DEPT CODE STU_LNAME STU FNAME STU INITIAL STUE_MAIL 9. Each student has an advisor in his or her department; each advisor counsels several students. An advisor is also a professor Draw the ERD for requirement 9 FIGURE 4.45 THE EIGHTH TINY COLLEGE ERD SEGMENT EMPLOYEE PK EMP NUM + a Isia EMP LNAME EMP_FNAME EMP INITIAL EMP EMAIL PROFESSOR STUDENT PK,FK1 EMP NUM PK STU NUM Ot! 4 - advises - PROF SPECIALTY STULNAME PROF RANK STUFNAME STU INITIAL STUE_MAIL FK1 EMPNUM 10. A CLASS is held in a ROOM. Each ROOM is located in a BUILDING. A BUILDING can contain many ROOMS, but each ROOM is found in a single BUILDING. Some BUILDINGS do not contain (CLASS] rooms. FIGURE 4.46 THE NINTH TINY COLLEGE ERD SEGMENT BUILDING ROOM CLASS PK BLDG CODE PK ROOM CODE PK - - contains - - CLASS CODE Lit is usedia od BLDG_NAME FK1 BLDG_CODE FK1 ROOM_CODE BLDG LOCATION ROOM_TYPE CLASS_TIME