Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Display all information about all courses that have no prerequisite 2. Add yourself as a new student to the Student table (use sequence STUDENT_ID_SEQ.NEXTVAL as

Display all information about all courses that have no prerequisite 2. Add yourself as a new student to the Student table (use sequence STUDENT_ID_SEQ.NEXTVAL as Student_ID and 07070 as zip) 3. List all students (display Student_ID, first name and last name) who live in zip 07070 4. Show how many students who have phone area code 212 (HINT: use the SUBSTR function) 5. List all student names who work for Electronic Engineers and registered on or after Feb. 3, 2007 6. List all courses that have "Intro to Information Systems" as prerequisite (HINT: use a subquery) 7. For all students who have phone area code 212, change the code to 202 while keeping the same phone number (HINT: consider using functions such as SUBSTR and LENGTH) 8. Delete your own student record added for query 2 9. Lower cost of all courses by 300 10. List all course costs (show course description and cost only) by the order of cost from lowest to highest (show courses without cost first)

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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2018 Dublin Ireland September 10 14 2018 Proceedings Part 1 Lnai 11051

Authors: Michele Berlingerio ,Francesco Bonchi ,Thomas Gartner ,Neil Hurley ,Georgiana Ifrim

1st Edition

3030109240, 978-3030109240

More Books

Students also viewed these Databases questions

Question

At what level(s) was this OD intervention scoped?

Answered: 1 week ago