Company Database Design Model

Introduction

As a requirement for our Database Management System I subject, we were assigned to create a database design model for a certain company. Since our instructor allowed us to select any company, we chose _____ ____ _____; further details about this establishment will be explained in the later part of this article.

It’s been known that a company with a good business design flow would most likely be much more prone to success since it is the foundation on how a company should develop and progress. It is where business experts and analysts base their critical decisions especially in the part where crucial events take place.

Probably one of the most important characteristics of good business plan and design is the structure of their Database. Database is a comprehensive collection of related data organized for convenient access, generally in a computer. It is where records of a certain company will be placed and stored. Accompanied with a good Management System for the Database will create a better impact on the company’s decisions relating business. Also, with proper Database Management System, the recordkeeping of the company will definitely be easy, fast and accurate.

Tackling about the advantages of a DBMS, it will also depend on the structure of the database and especially the software being in use. In this project, we shall develop a database design for the company _____.

Background of the Company

Services

_____ is a business establishment related to different computer services. Their range of services is as follows:

1. Computer Rentals

2. Computer Repairs

3. Computer Software and Hardware Installations

4. Invitation Cards Design and Production

5. Cards and Document Laminations

6. Personalize...

... middle of paper ...

...s been given a relationship with the Income Entity. Also, since, it is a fact that each service has a corresponding client and an optional charge; they are commonly interconnected with the Client and Charge Entities, respectively. The charges were defined as part of the Income, so any charge along with its description is related to the Income entity. The Expenses may not be directly related to each Service entity since it has to pass to the Raw_Materials entity which includes the Purchase Order information.

The relationships above are not specifically defined since most entities especially those which are Foreign by nature are of 1: 1 basis. Only those related to the Client entity may have relationships of more than 1 Client per service. Finally, Charges are ultimately optional. It may only occur once different considerations may arise such as extensions of service.