Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Program will be written in SQL. Create a STUDENT database. The purpose of the database is to store and retrieve student personal information and student

Program will be written in SQL. Create a STUDENT database. The purpose of the database is to store and retrieve student personal information and student academic information. The personal information includes student ID, SID, student last name, SLNAME, student first name, SFNAME, student address, SADDRESS, and student phone, SPHONE, student email address, SEMAIL, and student SETHNICITY. SID is the primary key. The academic information includes student High School, SSCHOOL, student GPA, SGPA, student courses, SCOURSE, and student credit hours, SCREDITS, and SID (both primary key and foreign key). The relationship between student personal information and academic information is one-to-one. Each student has one student financial aid information, SFINANCIALAID. The attributes of this entity will be SFINANCESOURCEID, SFINANCESOURCE, SFINANCEAMOUNT, and SAWARDDATE, and SID (both primary and foreign key). 1. Write down the different steps of developing this database. 2. Provide the ER diagram. 3. Create the tables, keys, and indices. 4. Write an SQL procedure and run it to insert 5 student information in the 3 tables. 5. Write an SQL procedure and run it to display all student phone numbers whose area code is 505. 6. Write an SQL procedure to retrieve all student last names who graduated from the same high school and whose GPA is higher than 2.5. 7. Write an SQL function to retrieve all student last names who earned above 15 credit hours. 8. Write an SQL view to retrieve student first and last name, and email address of all students. 9. Create an SQL trigger to stop any student records from deletion. 10. Create an SQL procedure to retrieve the student academic information who received the maximum financial aid.

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

Oracle 11G SQL

Authors: Joan Casteel

2nd Edition

1133947360, 978-1133947363

Students also viewed these Databases questions

Question

What is topology? Explain with examples

Answered: 1 week ago

Question

Discuss attention and its role in message processing.

Answered: 1 week ago