PROJECT INFORMATION: Selecting an Appropriate Data Base

1
PROJECT INFORMATIONSelecting an Appropriate
Data Base

• CIT 3413
• Advanced Data Base
• Dr. Segall
• Spring 2007

2
SELECTING A DATA BASE

• 1. Pick a database of interest to you and your
  
• teammates.
• 2. Be certain that the data base that is selected
  
• has ENOUGH DATA e.g.
• (i) ENOUGH CATEGORIES
• (ii) ENOUGH ATTRIBUTES
• (iii) ENOUGH ACTUAL DATA FOR EACH OF THE
  SELECTED CATEGORIES ATTRIBUTES. (ex. Circuit
  City did NOT have many items in video and DVDs
  but an significant number of items for TVs.)

3
SELECT DATA BASE CATEGORIES

• When your team is convinced there is enough data
  for selected data base
• (i) SELECT 3 or 4 categories of your data base.
• Example 1 FORD database
• Select categories of for example
• CARS, TRUCKS VANS
• Example 2 BEST BUY Database
• Select categories of for example
• LAPTOPS/NOTEBOOKS
• REFRIGERATORS
• TELEVISIONS
• (ii) SELECT what SUBSET of DATA for each of the
  
• SELECTED CATEGORIES will be used.

4
SELECT SUBSETS OF DATA BASE CATEGORIES

• For example
• CARS Crown Victoria, Lincoln Town Car, Ford
  Focus
• TRUCKS Ford F150, Ford F250, Ford F350
  (Dimensions Capacities of each are identical!)
• VANS Ford Freestar, Mercury Monterey
• (Dimensions Capacities of each are identical!)

5
Access Database
6
DETERMINE DIVISION OF LABOR

• Decide on DIVISION OF LABOR for each
• Phase of Project
• That is, which team members would be doing what
  for each phase.
• Aim to make the DIVISION OF LABOR equitable,
  I.e. all team members doing the same amount of
  work.

7
PHASES OF SEMESTER PROJECT

• PHASE I Draw E-R Diagrams for each of the
  SELECTED CATEGORIES
• For example
• E-R Diagram for CARS
• E-R Diagram for TRUCKS
• E-R Diagram for VANS
• If the CATEGORIES selected are HOMOGENEOUS (i.e.
  all the same types of items (e.g. vehicles)),
  THEN
• The other E-R diagrams may be DERIVABLE from the
  first E-R diagram!!)

8
PHASES OF SEMESTER PROJECT

• COMMON MISTAKE in E-R diagrams
• EXAMPLE
• ?RED is NOT an attribute! RED IS NOT A
  DATABASE!!
• RED is an INSTANCE of the ATTRIBUTE
  COLOR!!
• COLOR is an attribute! COLOR is a
  DATABASE!!
• ? Hence, RED should NOT appear in any ellipse!
• ?COLOR should appear in an ellipse!
• NEVER PUT INSTANCES OF ATTRIBUTES IN AN ELLIPSE
  IN E-R DIAGRAM!!!

9
PHASES OF SEMESTER PROJECT PHASE I

• PHASE I DRAW OBJECT-ORIENTED DIAGRAMS (OODs)
  for the DATA BASE selected.
• For Example OOD for DOMESTIC operations
• OOD for INTERNATIONAL
  operations
• FORD Database has different VEHICLES that it
  manufactures overseas than DOMESTICALLY!!! IF
  your database is similar to this, be prepared to
  discuss this when Dr. Segall meets with your
  team!!!
• Recall that OBJECTS have OBJECT NAME,
  ATTRIBUTES, OPERATIONS.

10
PHASES OF SEMESTER PROJECT PHASE II

• PHASE II MAKE CORRECTIONS TO PHASE I INDICATED
  BY DR. SEGALL
• Draw ENHANCED E-R DIAGRAMS (EER)
• NORMALIZATION
• 1NF, 2NF, and 3NF for each CATEGORY (e.g.
  CARS, TRUCKS, VANS)
• Again, if you selected a HOMOGENEOUS CATEGORIES,
  then 1NF of other categories MAY be derivable
  from 1NF of other CATEGORY!!!

11
PHASE II NORMALIZATION

• LOOK AT HANDOUTS!!!
• RECALL
• 1NF The Key
• 2NF The WHOLE KEY
• 3NF Nothing but the Key

12
PHASES OF SEMESTER PROJECT PHASE III

• PHASE III MAKE CORRECTIONS TO PHASE II
  INDICATED BY DR. SEGALL
• START ORACLE SQL MS ACCESS COMPUTER WORK
• CREATE DATA BASES in ORACLE SQL MS ACCESS
• POPULATE DATA BASES WITH ACTUAL DATA (i.e.
  available on web)
• PERFORM QUERIES ON DATA BASES CREATED!!
• QUERIES WILL BE BOTH SINGLE TABLE QUERIES
  MULTIPLE TABLE QUERIES!!!

13
FINAL PRESENTATION FINAL PROJECT REPORT
SUBMISSION

• CLASS TEAM PRESENTATION that gives an overview
  of entire semester project.
• Expect 30-minute presentation time for each team.
  One Q A for each presenter as part of Take-Home
  Final.
• FINAL PROJECT SUBMISSION Due Friday, April 30,
  2004.
• Includes CORRECTIONS TO PHASE III.
• COMPLETION OF ORACLE SQL MS ACCESS computer
  work!!!