Course Project
DeVry University
College of Engineering and Information Sciences
Course Number: CEIS236
Background
Modern daily life is almost inconceivable without databases. Online transactions, course catalogs, search engines, etc all use databases. We depend on databases for many aspects of our lives. It is important that these databases are designed and implemented co
ectly. With the increase of the Internet of Things and growth of online transactions database design, implementation, and management has many employment opportunities. This project walks through the process of design, development, and implementation of a relational database.
Scenario
Design a database system using ER diagrams and normalization. Create the database in a Relational Database Management System using SQL and create queries to retrieve data from the database.
Module 2: Conceptual Database Design
Objectives
· To understand and develop business rules
· Create ERD
· Create UML class diagrams
Steps
1) PART I: Write the business rule(s) that govern the relationship between AGENT and CUSTOMER.Â
PART II: Given the business rule(s) you wrote in Part 1, create the basic Crow's Foot ERD using Microsoft Visio.Â
PART III: Using the ERD you drew in Part 2, create the equivalent object representation and UML class diagram. (Use the following figure as your guide.)Â
Deliverables
· Complete the Course Project Deliverable
CEIS236 Final Project Ru
ic
Performance
Fail
Good
Excellent
Points Awarded
Total Possible Points
Points
0
5
10
10
Part I:
Co
ect business rule
No rule was identified.
Rule was developed but contained e
ors.
Logical business rule.
Points
0
5
10
10
Part II:
ERD diagram
No diagram was submitted.
ERD diagram was submitted but contains some e
ors.
Co
ect diagram.
Points
0
5
10
10
Part III:
Object representation and UML class diagram
No diagram was submitted.
Object representation and UML class diagram was submitted but contain e
ors.
Co
ect diagrams.