Question
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
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