Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

RELATIONAL DATABASE DESIGN USING SQL STATEMENTS 50 points Group will create a Class Session and Student Enrolment database application using Microsoft Access and relational model.

image text in transcribed
image text in transcribed
image text in transcribed
RELATIONAL DATABASE DESIGN USING SQL STATEMENTS 50 points Group will create a Class Session and Student Enrolment database application using Microsoft Access and relational model. The relational database application will demonstrate the ability of a database to capture, store, and report on data and information through the use of SQL syntax. Specific instructions, concepts, expectations, and demonstrations of coding SQL in Access will be provided during scheduled class lecture time as stated in the syllabus. It is highly recommended that you attend all scheduled class sessions to obtain al the necessary skills and understanding to complete this assignment Your final deliverable for this project is a Microsoft Access File containing a sequence of SQL statements that will recreate the database design from Part 1 of the project in Microsoft Access. Your submission will need to include the following Note: Name all your queries in the Access file with the naming convention that starts with #. Example" I CREATE Session Table", "2 CREATE Student Table. "x Select...,etc Database Entities &Attributes Requirement: You will use CREATE and ALTER SQL Statements to create the following database structure in Access. Please refer to Access Group Project Part 1 Guideline for details of the Attribute requirements. StudentTable SessionTable SessionTitle ScheduleTable SchedulelD StudentiD StudentEmailAdd SessionMaxCapacity Data Requirement: You will use INSERT Statements to populate the Student Table with the following data. 1 Kan 2 lane 3 Jason 4 Susan 5 Aron 6 Zack Wang Smith Cady Thomas Chen Del Pizzo 234 Street Ave 99 ABC Street kanwang@uor.edu(123) 456-7890 anesmith ucr.edu (293) 749-3274 8372 Crest Lane susanthomas@ucr.ed (238) 746 8237 aronchen ucr.edu (987) 324-8768 9287 Lemon Street 55555-5555

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Modeling And Design

Authors: Toby J. Teorey, Sam S. Lightstone, Tom Nadeau, H.V. Jagadish

5th Edition

0123820200, 978-0123820204

More Books

Students also viewed these Databases questions

Question

How does postponement differ from assembletoorder?

Answered: 1 week ago

Question

Explain the concept of careers and career paths.

Answered: 1 week ago