Practice, Practice, Practice
The solutions to problems 1-10 from your text, chapter 3 are presented in this document.
I advise you to answer the questions on your own and then compare your solutions with
those found in this document. You can also try the
Lesson 3 Supplement
Since the best method for learning Data Modeling is practice, practice, practice, what follows is
the problems and solutions from your text. You should work the problems on your own and then
compare your results with those found below.
Introduction to Structured Query Language (SQL)
Several points are worth emphasizing:
We have provided the SQL scripts for both Chapters 7 and 8. These scripts are intended to
Chapter 8 Advanced SQL
flow of the material presented to the class. However, given the comments made by our
STUDENT DATABASE SCHEMA
LETTER_GRADE (PK) GRADE_POINT MAX_GRADE MIN_GRADE CREATED_BY CREATED_DATE MODIFIED_BY MODIFIED_DATE VARCHAR2(2) NUMBER(3,2) NUMBER(3,0) NUMBER(3,0) VARCHAR2(30) DATE VARCHAR2(30) DATE NOT NULL NOT NULL N
Lesson 10 Supplement
The following provides the solutions for problems 1-10 from chapter 4. You should
work the problems on your own and then compare your results with the following.
The problems use the tables of the Order Entry database introduced in th
Lesson 8 Supplement
Overview of Physical Database Design
To become proficient in physical database design, you need to understand the
process and environment.
Physical Database Design is characterized as a series of decision-making
Lesson 6 Supplement View Design and Integration is an important skill for designing large databases. Large databases can involve ERDs with hundreds of entity types and relationships. Also, hundreds of forms, reports, and computer programs are used in the
Lesson 5 Supplemental
Chapter 11 applies the knowledge and skills necessary to a moderate-size case. Please
review the case thoroughly to ensure comprehension. A few supplemental notes follow.
Because most FDs involve a primary key on the left-hand side,
Lesson 4 Supplement
Unexpected side effect
Insert, modify, and delete more data than desired
Caused by excessive redundancies
Strive for one fact in one place
Big University Database Table
Lesson 2 Supplement
Relational databases are the dominant commercial standard
Simplicity and familiarity with table manipulation
Strong mathematical framework
Lots of research and development
Relational model basics:
Database Collection of related tabl
Lesson 1 Supplement
Most organizations are suffering from information glut. They have far more data than they know
what to do with, and not enough information.
Data raw facts
Information data that is organized into a meaningful format.
A database is a col
INSTALLATION INSTRUCTIONS FOR THE STUDENT SAMPLE
This document describes the files and steps used to create the STUDENT
schema, which is used for all exercises in the Oracle by Example series.
This document is organized as follows:
Microeconomics for Policy Analysis
University of Toronto
Fall Term 2015
Problem Set #1
Suppose that an individual has $180 to spend on two goods x and x . The price of
x (i.e., p ) is $10 per unit and the price of x (i.e., p ) is $5 per unit.