Scribd Logo
Upload

Welcome to Scribd!

  • 21 views

    Exercise 01 - Create Database Design: Estimated Completion Time: 60 Minutes

    Uploaded by

    Gyan Bshn
    The document describes normalizing a database structure with information about courses, sections, instructors, students, enrollments and grades. Each course has multiple sections taught by different instructors. A student can enroll in one or more sections or inquire without enrolling. Their grade is based on enrolled sections.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd

    Exercise 01 - Create Database Design: Estimated Completion Time: 60 Minutes

    Uploaded by

    Gyan Bshn
    21 views3 pages
    The document describes normalizing a database structure with information about courses, sections, instructors, students, enrollments and grades. Each course has multiple sections taught by different instructors. A student can enroll in one or more sections or inquire without enrolling. Their grade is based on enrolled sections.

    Original Description:

    dvdfv

    Original Title

    ActivitySolutions_1.0_Module3_DatabaseDesignTechniques

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes normalizing a database structure with information about courses, sections, instructors, students, enrollments and grades. Each course has multiple sections taught by different instructors. A student can enroll in one or more sections or inquire without enrolling. Their grade is based on enrolled sections.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    21 views3 pages

    Exercise 01 - Create Database Design: Estimated Completion Time: 60 Minutes

    Uploaded by

    Gyan Bshn
    The document describes normalizing a database structure with information about courses, sections, instructors, students, enrollments and grades. Each course has multiple sections taught by different instructors. A student can enroll in one or more sections or inquire without enrolling. Their grade is based on enrolled sections.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    You are on page 1of 3

    RDBMS

    Unit: Introduction To RDBMS and SQL Module 3: Database Design Techniques

    Exercise 01 Create Database Design


    Estimated Completion Time: 60 minutes

    Overview
    This exercise will require participants to design the database using normalization techniques. Participants should identify the primary key and will link the two tables via a foreign key.

    Instructions
    The normalized structure should be created using the Microsoft Word. 1. In order to proceed with normalization, first analyze the given data structure and identify all related data elements. If required or needed create new data elements create new tables or reuse the data elements. Data elements and tables should be unique. Name the tables with <tablename>_INFO.

    Hints
    1. Ensure the following while normalizing the table:

    Each course has many sections and the sections are taught by different instructors.

    A student may enroll in 1 section or many sections or may not enroll in any sections. i.e., the student may come just for inquiry of a particular course but may not necessarily enroll. A student is awarded a grade based on the sections that he/she has enrolled for. Each section may have different grade types and it also stores how many times the student has taken an exam and has received a grade.

    RDBMS 2007 Accenture. All Rights Reserved.

    146955496.doc3

    RDBMS

    Unit: Introduction To RDBMS and SQL Module 3: Database Design Techniques

    Data Structure
    1) Table Name: ZIPCODE_INFO Field Name ZIP_CODE CITY STATE 2) Table Name: INSTRUCTOR_INFO

    Field Name INSTRUCTOR_ID INSTRUCTOR_FIRST_NAME INSTRUCTOR_LAST_NAME STREET_ADDRESS ZIP_CODE 3) Table Name: COURSE_INFO Field Name COURSE_NO COURSE_NAME COURSE_PREREQUISITE COST 4) Table Name: STUDENT_INFO Field Name STUDENT_ID STUDENT_FIRST_NAME STUDENT_LAST_NAME STREET_ADDRESS ZIP_CODE

    5) Table Name: SECTION_INFO


    RDBMS 2007 Accenture. All Rights Reserved. 2 146955496.doc3

    RDBMS

    Unit: Introduction To RDBMS and SQL Module 3: Database Design Techniques

    Field Name SECTION_ID COURSE_NO SECTION_NO INSTRUCTOR_ID LOCATION CAPACITY

    6) Table Name: ENROLLMENT_INFO Field Name STUDENT_ID SECTION_ID ENROLLMENT_DATE

    7) Table Name: GRADE_INFO Field Name STUDENT_ID SECTION_ID GRADE_TYPE_CODE GRADE_CODE_OCCURANCE NUMERIC_GRADE

    RDBMS 2007 Accenture. All Rights Reserved.

    146955496.doc3

    You might also like