Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Guys, I really need help with this lab. Design the database portion of a system that will be used to test students electronically at the

Guys, I really need help with this lab. Design the database portion of a system that will be used to test students electronically at the end of 5th grade (Elementary school). The resulting grade for each student will determine whether they can advance to the 6th grade (and into Middle school), or have to stay back and repeat 5th grade. Each student is associated with a school, that is within a city, that is within a county. To do: 1. Analyze the problem description and decide what entities, attributes and relationships are needed to support the software that will be written. 2. Create the Entity-Relationship Diagram (ERD), using Crow's Foot notation. 3. Write the SQL code to: a. Create the tables. b. Insert substantial test data into each table.(populate tables with data) Minimum 10 students, from at least 2 schools; for a minimum total of 10 students. c. Write a Select statement to contain data that could be used to produce the desired report. 4. Submit a. project summary/write-up/report b. The ERD. c. The SQL code.

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

Step: 3

blur-text-image

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

Spatial Databases A Tour

Authors: Shashi Shekhar, Sanjay Chawla

1st Edition

0130174807, 978-0130174802

More Books

Students also viewed these Databases questions