Database Project Abstract

DatabaseProject

Abstract

Adatabase is a set of structured data that is stored in a computer andcan be mainly accessed in some ways. The use of a database systemplays a significant role in any organization. It is through adatabase that a company can store data about its employees orproducts. A database has various advantages compared to the oldsystem of using record books. A database system can be shared widelyhence it is easy to back up the database unlike the use of a recordbook where if anything happens to the record book important datamight end up getting lost. A database enables a company to share itsdata with its branches that are in other towns with the use of aninternet connection. Sharing the database reduces the time used tomake calls to ask about a certain product that is in stock. Forexample, a hardware shop that is an affiliate of a company thatsupplies hardware materials needs to communicate with the company toget more stock. It is through access to the company’s database thatthe hardware shop will effectively know the what is in stock thatthey can order. A database has many applications in our modernsociety and this paper I’ll discuss a database design for aconstruction company.

Thepurpose and goal of the project

Thepurpose of this project is to create a database for a constructioncompany. The database will be simple because the company does nothave a lot of employees. The goal of the project will be to create anefficient database that meets the threshold a good database shouldhave. The database will enable the company to store the data aboutthe employees and their current projects among other things.

Usersand Administrators of the database

Thedatabase will be used by the employees of the company and theadministrators being the human resource manager and finance officers.The employees will be using the database to record the number ofhours that they have worked on the construction site. The financemanager will use the database to calculate the wages owed to theemployees by the company. The use of hours worked by an employee willplay a significant role in calculating the wages for the employees.The human resource manager will use the database to record thedetails of employees as well as assign them with duties that theyshould work on.

Theimportance of the database.

Initially,the company was using record books to store data about the employees.The employees would personally record the time that they have worked,and it was cumbersome. Some of the employees used to forge the timethey took to complete a project, and it cost the company a lot ofmoney. If the workers falsify the time, it will lead to the projectconsuming a lot of time than the speculated time and the cost ofconducting the project will increase. There are chances when therecord books cannot be used concurrently by the human resourcemanager and the finance officer. Such situations meant that oneperson can only use the record books at a time. Therefore, a lot oftime was being wasted. Time was not efficiently used because at somemoment one of the employees would find themselves being idle.

Adatabase will solve the majority of problems that a record bookbrings in a company. The use of a database will reduce the chances oftime forgery by the employees. For example, the database will belinked with a fingerprint sensor such that when the employee placestheir finger on the sensor it automatically saves the time that theemployee has left work. A database will enable the employees to lookat the database data concurrently through networking. The databasewill be shared across every computer that is in the company such thatany employee can have access to the database without interfering withanother employee.

Dataelements that will be used.

Thedata elements that will be used will include tables and relationshipentities. The database will have a couple of tables which will helpin reducing data redundancy, update anomaly, delete anomaly andinsertion anomaly. There will be relationships between the tables inthe database system.

ThePlatform that will be used.

Theconstruction company does not have a huge number of employees henceit will be advisable that the company to use MS access to create itsdatabase.MS access has a lot of advantages and the main being thatit’s user-friendly to the users. The users will easily learn how touse MS access with no difficulties.MS access is also very cheap tomaintain because it does not require any administrative duties,unlike other complex database systems. If the company expands and thenumber of employees increases the company will need to use moreadvanced database systems like Oracle, MySQL, etc.

Normalizationof the database.

Itis important to normalize a database to reduce the chances of dataredundancy, insertion anomaly, delete anomaly and update anomaly.Normalization also helps a new administrator to understand thedatabase system well as it serves as a blueprint for the database.

Beforethe database is taken through normalization, it will consist of onetable that will hold the details of the company. The table will havethe following attributes

Project n.o

Project name

Employee name

Employee Number

Job Class

Charge per hour

Hours

Thedatabase will have seven fields as indicated in the table above.

Whennormalization is done on the database, the number of tables willincrease to ensure that the database is efficient. The database willnow consist of four tables respectively which will be named asfollows Project, Employee details, Job and Assign.

ProjectTable

Project Number Project Name

EmployeeTable

Employee n.o Employee Name Job Class

AssignTable

Employee N.o Project Number Hours

JobTable

Job Class Charge per hour

Theunderlined fields in the above tables indicate that they are primarykeys.

FunctionalDependency Analysis

Project n.o

Project name

Employee name

Employee Number

Job Class

Charge per hour

Hours

PartialDependencies

PartialDependencies

TransitiveDependencies

Thediagram above indicates the functional dependencies that the fieldshave on each other. It is important to note the underlined fields arethe primary keys. The primary is a column that is used to identifyuniquely a table of records, and it can never contain null values.

References

Özsu,M. T., &amp Valduriez, P. (2011).&nbspPrinciplesof distributed database systems.Springer Science &amp Business Media.

Bechhofer,S. (2009). OWL: Web ontology language. In&nbspEncyclopediaof Database Systems&nbsp(pp.2008-2009). Springer US.

Elmasri,R., &amp Navathe, S. (2011).&nbspDatabasesystems&nbsp(Vol.9). Pearson Education.

Dix,A. (2009).&nbspHuman-computerinteraction&nbsp(pp.1327-1331). Springer US.