Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 19 21 2012 Proceedings Part 3 Lnai 7198

Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen

2012th Edition

3642284922, 978-3642284922

More Books

Students also viewed these Databases questions