Assessment 2 - Data Modelling for Granite Sales Company

Assessment 2 – Data Modelling
Granite Sales Company
Submitted By
Course
Professor
Date

Introduction
Granite Sales Company maintains all records on staff as well as the divisions that they work in.
For every division, the name of the department, their mail box number, and office telephone
extension must be stored. Many employees can work in a department whereas one employee
can work in one department only. Employees can be categorized in three categories - salaried,
hourly and contract employees. Employees can be uniquely identified by unique employee
number. In case of hourly employees, target weekly hours will also be stored. Salaried
employee can have some commission profit which must also be saved into the database. In
case of contract employees, their contract rate with contract start date and end date will be
saved into the system. Being database administrator, my job is to prepare well defined entity
relationship diagram and then implement it correctly in Granite Sales Company.
Business Rules
Distinguishing and archiving business rules while developing and implementing database are
very important for planning a database in the organization. Business rules can enable the
developer for developing various relationship guidelines and requirements and for developing
correct information model. They additionally enable us to comprehend business processes, and
the quality, role as well as scope of the information. These guidelines are considered as a
specialized tool among clients and developer, and can help to standardize the organization's
perspective in terms of information. It is essential to recall that few of the business rules can't
be shown. Business Rules give the most ideal order of entities, properties, relations, and