Intro to SQL - Final Project - Google Docs

.pdf

School

University Of Arizona *

*We aren’t endorsed by this school

Course

2

Subject

Information Systems

Date

Feb 20, 2024

Type

pdf

Pages

6

Uploaded by MateSteelGerbil31

Report
Project : Student Functionality Requirement Students, Topic : Courses and Tutors The following data model is designed to hold information relating to Students, Student Courses and Instructors who tutor students. For this scenario, we need to define the following entities: ● Student Information ● Courses ● Student Courses (enrollment) ● Employees (instructors) ● Student Contacts (Contact between the Student and the Instructor) ● Contact Types (Tutor, Test support,etc..) The entities are based on the ER diagram below and use the following rules to determine the table relationships. ● A Student can enroll in one or many Courses ● A Course can have one or many Students enrolled in it. ● A Student can have zero, one, or many forms of contact with the Course Tutor ● An Employee (Tutor) can have many contacts ● A contact Type (Tutor, Test support,etc..) can have zero, one, or many contacts The design allows ~ ● a Student to enroll in one or multiple Courses, ● a Course allowing one or more Students enrolled in it. ● a student may be in contact with the Course Tutor many times using many different forms of contact. ● an instructor can connect with many contacts involving many Students
Entity Relationship Diagram (ERD)
Setting up the project 1. Make a copy of the FinalProject.sql template file (also linked in Canvas) to help guide you through the project. a. Download it as a text file and work on it locally (can still have the .sql extension) b. In Google Drive -> File->Download As -> Text File 2. Read through the A-I part (sections) below, and add your responses to the problems in your local copy of the project.sql file. 3. Ensure the ENTIRE project.sql runs without errors (use sql commenting if there are any problems you are unable to finish) 4. Upload your FinalProject.sql text file through Canvas in the Final Project Assignment. Notes on project.sql : Each part has some documentation (below and in the project.sql template) to describe the specific statements needed to answer each part. While the execution order of the script should remain sequential (e.g. Part C executes before B, which executes before A), the order in which you work on the script can happen in any order you want (e.g. if you want to start with part G, and it doesn’t depend on something earlier in the script, go for it). Also, the HINTS with test data are merely “examples”, and are NOT REQUIRED in your response. They are there to help guide you. I’ll be looking at how you constructed your logic for each of the Parts below instead of resulting data from each Part’s query execution. The total project is worth 280 points Rubric: ● Part A & Part F are supplied 0 points ● No errors when executing the entire script - 25 points ● Part B - 40 points ● Part C - 60 points ● Part D - 25 points ● Part E - 40 points ● Part G - 40 points ● Part H - 25 points ● Part I - 25 points Part Task Descriptions ● Part A - Creating the database ○ Use the provided template, no action required.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help