Info 275- TERM PROJECT 

Project Resources

|Groups|

 Objectives

• To gain familiarity with the database design process.
• To gain familiarity with the features and functionality of major state-of-the-art microcomputer DBMS/PIM packages
• To be able to use the software and develop an application
• To know and understand software evaluating criteria and methodology used in the industry
• To be aware of the major sources of information on software

Deliverables

1. A Report on the Outcome of Database Design *
2. Soft copy of the database prototypes (Access and another DBMS of your choice). 

	Implement the prototype in MS Access and another DBMS of your choice
	Ensure that your prototype has the following:

• Twelve Entities
• Data entry forms for each entity
• Six Queries in case of Access & 12 Queries in case of Oracle. (Use two/ three table join)
• Six Reports (No need for reports in case of Oracle. For Access, yes.)
3. Compare the selected DBMSs on the following aspects:
• Hardware requirements
• Operating Systems
• Views of Industry users
• Your own experience and views on the product

* Guidelines for the Database design process.
Conceptual Database Design
Step 1         Build local conceptual model for each user view
Step 1.1 Identify entity types (minimum 12)
Step 1.2 Identify relationship types
Step 1.3 Identify and associate attributes with entity or relationship types
Step 1.4 Determine attribute domains
Step 1.5 Determine candidate and primary keys
Step 1.6 Specialize/ Generalize entity types (optional step)
Step 1.7 Draw the Entity-Relationship Diagram

Logical database design for the relational model
Step 2         Build and validate local logical model for each user view
Step 2.1 Map local conceptual data model to local logical data model
Step 2.2 Derive relations from local logical data model
Step 2.3 Validate data models using normalization (upto THIRD Normal Form)
Step 2.4 Validate model against user transactions
Step 2.5 Draw the Entity-Relationship Diagram
Step 2.6 Define entity constraints

Step3         Build and Validate global logical data model
Step 3.1 Merge local logical models into global model
Step 3.2 Validate global logical data model
Step 3.3 Check for future growth
Step 3.4 Draw final Entity-Relationship Diagram

 

Important considerations for a good grade

• Breadth, depth, accuracy, and currency of content
• Organization and style of the paper and presentation
• Demonstration of the software capabilities

Team Peer Evaluation
In order to ensure equitable sharing of the work load, each person will evaluate the other members of the team. An evaluation form will be provided. The evaluations will be treated confidentially. If evaluations are not turned in, you will loose the individual grade.

Project Grading Scheme 

Project 35% (25% Group; 10% for Individual) 
(Individual grading is based on peer level evaluation and presentation) 

For Group: 
Paper : 50% (Database Design Process (Steps): 40% 
Database comparison- 10%) 


Prototypes: 
Access prototype: 25% 
Oracle/other DBMS - 25% 

(Deliverables for Oracle: SQL commands for Tables creation, insertion, Queries,
and print out of reports) 

The Project deliverable 2 is due by Friday, November 25. Create a folder in your 'W' drive and name it as 275_Project. Make sure the following are available in this folder on or before the due date:

1. A zipped version of your Access prototype
2. Oracle/ Other DBMS SQL Commands for table creation and Queries
3. Database comparison (1-2 pages)

GROUPS

Presentation Schedule

Tuesday, November 29

Group 1:  

Group 2:  

Friday, Dec. 2

Group 3: -

Group 4:  

Group 5:

By GROUP members