Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the Registration create script to answer these questions. We will use the below area to write our test SQL . * * * *

Use the Registration create script to answer these questions.
We will use the below area to write our test SQL.
******************/
/*1) How would you add a grade attribute (Char with length 1)
to the Registration table? */
/*2) How would you remove Elliot's registration to INFO 1003?*/
/*DELETE*/
/*3) How would you create a new MathCourses table? */
/*4) How would you insert MATH1315 College Algebra to the MathCourses table? */
/*5) How would you show the rows of the MathCourses table to make sure you
inserted MATH1315 successfully? */
/*6) How would you remove the MathCourses table? */
/*7) Show which Section has the most registrations. */
/*8) Show which Student has the highest ID number. */
/*9) Show the Courses in alphabetical order by CourseID */
/*10) Which students are registered for a section? */
/*11) How many classes are each student registered for? */

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

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions