#1. Display the manager number and the salary of the lowest paid employee for that manager.
Exclude anyone whose manager is not known. Exclude any groups where the minimum salary is
less than $1000. Sort the output in descending order of salary.
1. Setup a department, course within a department with 2 sections. Section must have a location assigned. Produce a
report showing the department, its course and sections (with complete section information.)
INSERT INTO FeeSchedule VALUES (9999, NULL, NUL
Lab Assignment # 1
1. What are primary and foreign keys? Explain in detail. What are the implications of using these
keys in different tables?
A: There are multiple types of keys but the two most important ones are the primary and foreign keys.
Q1. Based on the schema in Lab 6, create tables with constraints. Consider using the following constraints as appropriate Primary Key,
Foreign key, Unique, Null or Check.
DROP TABLE StudentFee CASCADE CONSTRAINTS;
DROP TABLE Section CASCADE CONSTRAINTS;
Lab Assignment # 3
#1. Write a query to display employee number, employee name, hiredate, manager's name for
those employees, whose manager's name starts with K or M or S. Label the columns Employee
Number, Employee Name, Hiredate, Mgr Name.
Lab Assignment # 5
Create a query that displays the employees names and indicates the amounts of their salaries through asterisks. Each asterisk signifies
hundred dollars. Sort the data in descending order of salary. L
1/5/2016 SQL Running Lecture Notes
Introduction to SQL (using Oracle)
Structured Query Language - Used for enabling interactions with database (relational) for
What is a database - different types of databases - relational
Intro to Basic features of Data Bases
Uses of SQL Basic Statements
Usage of Joins (Both Syntax)
Email test to class
Email back by 1030 -> cis