Overview You work for My Favorite University and have been tasked with designing and developing the portion of the database needed to support the Student Information & Schedule application form below....

Overview
You work for My Favorite University and have been tasked with designing and developing the portion of the database needed to support the Student Information & Schedule application form below. The database must include student biographic, academic and class schedule data. Multiple entities are required and all data elements on the form must be included in the database. Apply the appropriate database design techniques covered this semester. Use appropriate data definitions for each data element and identify all necessary keys.

Use the MS Access database (ITEC315_Project.accdb) provided to get started (includes several tables with some data). Add any additional table(s) necessary to support the application form. Create SQL command/procedure queries to create the STUDENT table, add 2 records to the STUDENT table, and modify a record in the STUDENT table. In addition, create a Select query to provide all data necessary for the Student Details and Academic sections of form below.

Requirements

1. UseVisio to create a fully attributed ER diagram(Crowfeet notation) to represent the database model. Be sure to include all entities, attributes, relationships and connectivities.

2. Using the attached MS Access database,create and save the SQL command/procedure query to create the STUDENT table. Name the queryCreateStudent.Be sure to include all necessary attributes with appropriate data types and appropriate keys (primary and foreign).

3. Create and save the SQL command/procedure query to delete the entire STUDENT table.Name the queryDropStudent.

4. Create and save the SQL command/procedure query to add a recordforMary C. Alexandarto the STUDENT table–include all appropriate data with appropriate data types from the form above. Name the queryAddStudent.

5. Create and save the SQL command/procedure query to add a recordforMaria Cinarosto the STUDENT table–include all appropriate data (see data below) with appropriate data types from the form above. Name the queryAddStudent2.

   ID = XXXXXXXXXX
   Maria Cisnaros
   854 Burke Ave
   Towson, MD XXXXXXXXXX2041 9/23/1996

   Male
   Major = Biology
   Minor = Sociology
   Advisor = Dr. Juan Issenberg GPA = 3.22
   Units = 54

6. Create and save the SQL command/procedure query to modify Mary C. Alexandar’srecordin the STUDENT table. Name the queryUpdateStudent.Update her address and phone to be:

   387 Chesapeake Ave Towson, MD XXXXXXXXXX5254

7. Create and save a Select queryto provide all data necessary for the Student Details and Academic sections of form above forMary Alexandar only. Name the querySelectStudentInfo. Note you will need to Join several of the tables to include all the information.

Submission

Submit two files via BlackBoard Assignments–(1) the final MS Access database (ITEC315_Project.accdb) and (2) the Visio ER diagram (ITEC315_Project.vsd). No other files or formats will be accepted!

Grading Rubric

Extra Credit

For 5 extra credit points, create and save a Select querytoprovide all data necessaryforthe Student Schedule section of form aboveforMary Alexandar only.Name the querySelectStudentScheduleand be sure to include all necessary schedule data.