Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started