Archives
Database Storage & Design Chapter 1 Homework Electronic Engineers And Have Last Names Starting With Rows select from where and order
Assignment #1 Simple Queries 1. Write a SELECT statement to list course data sorted by course number. (30 rows) 2. Write a SELECT statement to list zipcodes and their cities in New York State sorted by zipcode. (123 rows) SELECT […]
Database Storage & Design Chapter 2 Homework Use Instr Produce The select Count Quot count Vs quot from Student where Instr lower last name v Gt
Assignment #2 String and Aggregate Functions 1. Create a list of all students with middle initials (specifically, with a first name AND then a middle initial) AND remove the middle initial from the first name. Take care: some first names […]
Database Storage & Design Chapter 3 Homework Max start datetime Min start date time course no Count course no from Section group Course no having Count course no Gt13 Display The Start Time Section
Assignment #3 Date and Conversion Functions Answers 1. Determine the Start Time for all sections of course 20. The time should be displayed as Month, Date, Year, Hour, and Minute, with a column alias of Start Time (4 rows). SELECT […]
Database Storage & Design Chapter 4 Homework Show The Number Enrollments For Section Course Number 350 Display Least Section and
Assignment #4 Joins 1. List all classes (course_no, section_no) taught by instructor Hanks. (9 rows) SELECT s.course_no, s.section_no 2. Show the student roster (use the format: <last name>, <first name> in a single column) for each section that Todd Smythe […]
Database Storage & Design Chapter 5 Homework List All Classes Course no Section no Taught Fernand Hanks Use Correlated Subquery 9 Rows select
Assignment #5 Subqueries 1. Show all the sections whose enrollment is greater than 5. Display course and section number. Do two versions – one using a join and the other with a correlated subquery. (10 rows) SELECT s.course_no, s.section_no 2. […]
Database Storage & Design Chapter 6 Homework Column For The Owner Username Ie The Logon Name Unique And Not
Assignment #6 DML, DDL, and Views 1) Create an empty table called SECTION2 with the same structure as the SECTION table. Create a view on the SECTION2 table that will be used for updating the table and restricts updates to […]
Database Storage & Design Chapter 7 Homework Role Instructor create Replace View Current regs As select Last name First name from Student where To chart run c registration date Mmddyyyy To chart run c
Assignment #7 Roles and Privileges Create two roles: REGISTRAR and INSTRUCTOR. Then create the following views and assign select rights on each set of views to the roles they are listed under: 1. REGISTRAR 2. INSTRUCTOR • ROSTER: all students […]
Database Storage & Design Chapter 8 Homework You May choose One The Data Dictionary Views You Wish You May Create
Assignment #8 Data Dictionary 1. Describe the data dictionary view called DICTIONARY. DESCRIBE dictionary 2. List the names of all the users whose objects you have access to in the database. 3. List the comments on the columns for the […]