Access database query, computer science homework help

User Generated

spuhtugnv

Computer Science

Description

Could you help me with the attached files regarding query and access 

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags