CIS 515 - Week 4 - Assignment 4 - DB Modeling and Normalization

This preview shows page 1 - 4 out of 9 pages.

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Oracle 12c: SQL
The document you are viewing contains questions related to this textbook.
Chapter 6 / Exercise 7
Oracle 12c: SQL
Casteel
Expert Verified
Running Head: DATABASE MODELING AND NORMALIZATION 1 Assignment 4: Database Modeling and Normalization Marcos A. Ortiz Albino CIS 515 – Strategic Planning for Database Systems Dr. Osama Murad Strayer University May 1, 2016
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Oracle 12c: SQL
The document you are viewing contains questions related to this textbook.
Chapter 6 / Exercise 7
Oracle 12c: SQL
Casteel
Expert Verified
DATABASE MODELING AND NORMALIZATION 2 Assignment 4: Database Modeling and Normalization Introduction The Public Government of Sugar Hill in Georgia (PGSH) has requested an optimized data repository for its current system which will enable the management staff to perform essential human resources (HR) duties along with the capability to produce ad hoc reporting features for various departments. They look forward to holding data that will allow them to perform core HR functions such as hiring, promotions, policy enforcement, benefits management, and training. Best Database Consulting (BDBC) has been awarded the contract to implement this new personnel system for PGSH. As part of the agreement we will be listing the process of the implementation in the following areas: (1) an efficient Entity Relationship Model (ERM) Diagram, (2) risks of not following with the designing steps for the ERM Diagram, (3) entities, (4) time-variant data, (5) Diagrams, (6) normalization and (7) dependencies. An Effective Entity Relationship Model Diagram A conceptual data model which defines the domain regarding entities, attributes and relationships are called an entity-relationship (ER). On an entity-relationship diagram (ERD) entities are represented as rectangles, attributes as ellipses and relationships between entities as diamonds (Chen, 1976). To have an efficient ERD, there are definitive steps that need to be addressed and is key that they are covered in a specific order. Although they are not set in stone, once identified the design flow needs to be followed. The steps that BDBC will follow to determine PGSH’s ERD will be the following: 1. Identify the entity types and assign a noun to each one. 2. Identify relationships amongst the entities and assign a verb to identify them. 3. Recognize the cardinality and optionality of the relationships.
DATABASE MODELING AND NORMALIZATION 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture