Due: BEFORE Monday of week 7
1 Change the file to read a1-your email id - of one of the members
2 Email the result to me and CC all member in the group
3 Not doing the above will result in a 25% deduction
Seneca College - DBS301
Find first earliest hiring date, latest hiring date, maximum salary among the
employees that work only under department 20,40,50,60 and 90.
Hint1: Use MIN, MAX and GROUP BY
Write a query that returns the depart
WORTH 5% OF THE OVERALL GRADE FOR THE COURSE
INTERNAL EQUITY (ALIGNMENT) AND EXTERNAL EQUITY (COMPETITIVENESS)
After reviewing the Wilson Brothers Case Scenario, as Director of Human Resources for the organization,
Seneca College - DBS301
Q1. (40 points)
Using the information provided in the supplementary files, you need to create
STUDENT Data model and provide SQL scripts with DML statements that will
implement a Physical Solution for STUDENT database
Part B: Multiple Choice Questions. Choose the best answer (10 m
/1. A permanent message queue is an object of type 61
both b and I:
user i A _. '
/ a) signs off to the system.
b calls any program in the system.
c signs on to the system
7 To @yommmgg to Iczeauuemillyse the
EJDIQuBLIB IBczasLIB I
both b and c
a) user created commands
b) system commands that can be called interactively
c) variables used in a CL procedure
special values that function
PART D: CL Programming (worth 20 marks)
a) CLLE program with display file
TEST 1 DD/DD/DD
Please select one of the following options:
1. Currency Symbol Used by this System
2. Display System Serial Number
Option: g; Valid option must be entered
Part A: True/False (10 marks)
True] False 1 mark each.
The current library is used when a user creates an object and does not state specifically what
library it is to be stored in
If yourfile wasicreatedfro
The SN DRCVF only sends a reco
b) CLLE program with display file
A manager would like to know the total salary For all his employees.
Write a CL program that would r-.d file TESTPF and calculates the total
s lar t = i , '_.L' 7 .
g4: T0T8LAb atg 0 _ _
PART 0: Physical Files cfw_5 Marks) 5
Write the DDS Code to cre - .~ - - ujehct thet store
@that uniquely identifiestL er. The numbershouldgsjore1m_ digit' In g 9
, on :n I - . 'th a maXImur'n value of m This' Is the primary key t
DBS301 Lab 5 Solutions - Simple Joins
1) Display the department name, city, street address and postal code for all departments
sorted by city and department name.
SELECT department_name, city, street_address, postal_code
FROM departments JOIN locations US
DBS301 Lab 5b Solutions non-simple joins
1) Display the location id, address, city , state and country for each location id.
SELECT location_id, street_address, city, state_province, country_name
LEFT JOIN countries using (country_id);
Practice Exercises SQL (1)
For the following exercises the collection name is: PREMIERE (see ERD on Page 5)
Selecting Attributes and Sorting
Produce a list showing Part_Number, Part_Description, On_Hand, and Price
sorted by Part_Description.
2. We can
DBS201-Summerl 2016 Test 1, Version 1
LOCATION OF PRODUCTS REPORT:
BP - Beauty P
DBS201 Assignment 2
10%of final mark
Your group of up to three people is to develop a conceptual database design for the following
description. There is penalty of 10% if submitted individually. Late submission has penalty of 10% for
each school day.
Student Name: _
Page 1 of 5
Total out of 45:
Draw ERD for the following problems. You can use Chen notation or crow-foot
notation. (13 marks)
Q 1. The Toronto city youth league needs a database system to help track children
that sign up to play
Practice Exercises SQL (2)
CREATE TABLE/CREATE VIEW/ALTER TABLE
For the following exercises the collection name is: ACME
And here is the ERD of the database:
Create a CAR table in the collection ACME which has:
[CarNo (PK) , Make, Model, Year, YearsOld
Part C - Encapsulation
In this workshop, you are to code a class that represents an enrollment and processes
transactions on that enrollment.
Upon successful completion of this workshop, you will have demonstrated
Part B - Foundations
Workshop 3 (worth 3% of your final grade)
In this workshop, you are to process an array of objects where the user specifies the
number of elements in the array at run-time.
Upon successful completion o
OOP244 Quiz #2 Section A
1. What is the cause of a memory leak? (1 mark)
A memory leak occurs if an application loses the address of dynamically allocated memory that
has not deallocated.
When memory has not been deallocated properly
2. Define a fun
I have given explanation of some of the questions. Please try them on matrix.
Each question has 1 correct answer. Circle the letter of each correct answer on the exam paper and
also transfer the answer t
Due Friday midnight of week 2
STEP 1: rename the file to L2-your id name
STEP 2: Put the SQL and the results after each question below
STEP 3: Email this back before the deadline with subject line L2-yourid and section id
Practices and Solutions
Table of Contents
Practices for Lesson I. 3
Practice I-1: Introduction . 4
Practice Solutions I-1: Introduction . 5
Practices for Lesson 1 . 11
Practice 1-1: Retrieving Data Using the SQL SELECT Statement . 12