This Project Will Not Be Accepted Late
CIS305 S `10
California State Polytechnic University, Pomona Database Design and Development Project #1 (30 points)
Case Study in Logical Database Design
Due Date: see course schedule
The objective of
TOM 302 Mid-term Exam
Thursday May 5 during class
Closed book, closed notes; 1 sheet of 8 by
Comprises 30% of course grade
Bring scantron, pencil, optional calculator,
Sheet of notes
1 sheet of 8 by 11 all
Cash Flow Estimation
Capital Budgeting decisions must be based on cash
flows not on accounting income
Identify and use relevant cash flows, and ignore
Picking up Relevant Cash Flows
Examples of Relevant Cash Flows
The Enhanced E-R Model
CIS 305 Dr. Sonya Zhang
Supertypes and Subtypes
Enhanced ER model: extends original ER
model with new modeling constructs
Subtype: A subgrouping of the entities in an
entity type that has attributes distinct from thos
The Database Environment
and Development Process
Dr. Sonya Zhang
Data vs. Information
Files vs. databases
Elements of database approaches:
Relational and OO
Components of database environment
Categories of database
Modeling Data in the
CIS 305 Dr. Sonya Zhang
Are the foundation of data models.
Are derived from policies, procedures,
events, functions, and other business
Represent fundamental business structure.
Relational (RDBMS) A database management system that manages data as a collection of tables in
which all data relationships are represented by common values in related tables.
Catalog A set of schemas that, when put together, constitute a description of a
Join A relational operations that causes two tables with a common domain to be combined into a single
table or view.
Equi-join A join in which the joining condition is based on equality between values in the common
columns. Common columns appear (redundan
Field the smallest unit of application data recognized by system software.
Datatype A detailed coding scheme recognized by system software, such as a DBMS, for representing
Denormalization The process of transforming normalized relati
Relation: A named two-dimensional table of data.
Primary key: An attribute or a combination of attributes that uniquely identifies each row in a relation.
Composite key: A primary key that consists of more than one attribute.
Foreign key: An attribute in
Figure 4-3 Schema for four relations (Pine Valley Furniture Company).
Monday, October 12, 2015
List five properties of relations.
It must have a unique name.
Every attribute value must be atomic (not multivalued, or composit
Chapter 2 - Chapter Objectives
Thursday, October 1, 2015
State reasons why many system developers believe that data modeling is the most
important part of the systems development process
- The characteristics of data captured during data modeling
Wednesday, September 30, 2015
Name several limitations of conventional file processing systems: (pg 8-9 figure 1-2) (slide 7)
- Program-data dependence.
All programs maintain metadata for e
Enhanced entity-relationship (EER) Model A model that has resulted from extending the original E-R
model with new modeling constructs.
Subtype A subgrouping of the entities in an entity type that is meaningful to the organization and that
shares common at
Define each of the following key terms:
Business Rule: A statement that defines or constrains some aspect of the business It is intended to
assert business structure or to control or influence the behavior of the business.
Term a word or phrase that has a
Define each term:
Data (Pg 5-6, figure 1-1) (slide 3-5) : Stored representations of objects and events that have meaning
and importance in the user's environment.
Structured: numbers, text, dates EX) customer name, address, telephone number.
You are going to use W3schools.com for the exercise
Go to http:/www.w3schools.com/sql/default.asp
You will use the Northwind database for all SQL exercises tonight
The database is built by WebSQL is a web page API for sto