Description
Could you help me with the attached files regarding query and access
Explanation & Answer
Dear student,Please find enclosed a doc file with the correct ER diagram and the SQL codes using the exact title names for each column in the ACCESS database.
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 a 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. Use Visio 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 t...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
The Eyes Were Watching God
by Zora Neale Hurston
Where'd You Go Bernadette
by Maria Semple
Cat on a Hot Tin Roof
by Tennessee Williams
Twilight
by Stephenie Meyer
All the Kings Men
by Robert Penn Warren
The Joy Luck Club
by Amy Tan
Jane Eyre
by Charlotte Brontë
The 5 Love Languages
by Gary Chapman
The Aftermath
by Rhidian Brook