This website uses cookies to ensure you have the best experience. Learn more

Company Database Design Model Essay

981 words - 4 pages

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. Personalized Gifts and Giveaways
7. Printing Services
8. CD and DVD Writing
9. Photo Scanning
10. Software Designs

Business Rules

Since we found out that the company we approached does not have any database management system, we suggested that we would design a database for them as well as discuss with them some of the business rules appropriate for their company. The business rules we have developed for ______ are as follows:
1. The rate for computer rentals shall be P5.00 per 30 minutes of usage. If a session of usage reaches more than the exact division of 30 minutes (example: total usage time is 2 hours and 7 minutes.), the excess of 7 minutes shall be charged P5.00. Therefore, as the example stated above, the user shall be charged for a total amount of P25.00. The first 30 minutes shall also be charged an amount of P5.00.
2. Computers to be repaired must be sent to the establishment. There shall be no home service allowed unless for some special cases. A home service may be performed but with some additional charges. A charge of 10% of the total repairs cost shall be applied.
3. The company shall not be held liable with regards to software piracy installations. The client should have with them their registered...

Find Another Essay On Company Database Design Model

project plan Essay

1524 words - 7 pages software development company. The company has at least sixty employees in different departments. Each employee also has specific pay category. In addition, employee role will be assign to each employee to determine the pay rate. The company has multiple projects which are the main company profit. Each project has its own team and client. Base on the company’s background and operation, the database design team came up with a design would best fit the

role of database administrator Essay

1611 words - 7 pages modifications to the database, they rarely work together with companies on a day-to-day basis. Companies need database administrators because technology is constantly changing to be better. The needs of database users are constantly changing. The company database administrator can hire database designers to come into an organization and design a database suitable for the organization. However, these designers are not required for everyday. Many

DATABASE MANAGEMENT AND INFORMATION RETRIEVAL

1548 words - 7 pages Data is the most important component of database management system. The main function of database management system is to process the data. Database are defined as the constructed and the data will stored, update and retrieve to and from the database. • Procedures. The procedures refer to the instructions and rules that help to design the database and to use the database management system. The users that operate and manage the database

Database Administrators

1268 words - 5 pages databases within an organization. Database designers might be employed by the company itself, or they might be employed by third parties and responsible for developing databases for many types of organizations. The database designer typically has an engineering or computer science background, and works with information supplied by knowledge managers and the end users in order to develop databases that meet specific needs. The database designer may

This paper talking about Database Management Systems

571 words - 2 pages creating a database design: data and functional model. The data model is the actual data and how it is managed. The functional model decides how data is supposed to be accessed, processed, and queried. In order to design the data model, the following steps have to be followed, (taken from the Information Technology Services page of the University of Austin) (2004):Identification of data objects and relationships: this is the analytical stage and

Bead Bar Network Design

3408 words - 14 pages Bead Bar Network Design The purpose of this project is to identify a computerized system that will align with the Bead Bar’s company goals. The Bead Bar is a company that supplies customers with workshops and materials to produce their own costume jewelry using items such as wire, beads and string. The Bead Bar is 1.5 million dollar company founded in 1998 that employee 15 full-time employees and 20 part-time employees

Huffman Trucking

2882 words - 12 pages benefits should help determine which option of database replication is the right one. (Blue Claw Database Design, 2004) The Fleet Truck Database Management System (DBMS) provides: ❖ Ease of use – This DBMS has a familiar Windows ‘look and feel.’ ❖ Support – Best-selling desktop database with future support from software parent company. ❖ Multi-User – It will operate on a network to support 255 concurrent users; however, a more

phase 1 individual project

2211 words - 9 pages appointments. These issues have created a lot of headache in the company which is why a well-organized, structured, and customer friendly database is required.Very few businesses today realize the power and possibilities that come with having a well-established data management system or database. Effectively managing your data will not only make your business immediately more efficient, but will directly raise your profit level. Surprisingly, there

Bead Bar Systems Development Plan

1739 words - 7 pages will employ the ring topology method along with client-server network architecture. Wireless technology will be used to provide the functionality needed to support all aspects of the company. The equipment necessary to support the client-server network will consist of a hub, wireless access points (WAPs), routers and servers. A relational database management system will be integrated into the information system using the enterprise database

various type of databases

633 words - 3 pages birth of the database blazed through the computer world, the company IBM (International Business Machines) was an integral pioneer in the developmental phases of the application. The construction of the database went through many stages; those stages are as follows, flat-line, hierarchical data model, network model, relational model and object oriented models. (McGee 1981 pg. 506-509) Each method of database development manifested a more

Various Types of Database Models

1558 words - 7 pages record which one step above the actual information or data. Figure 7. Hierarchical Model The relationship in this case is parent child with one parent and many children. 1.2 Network Database Management System Network database model is somewhat similar to the hierarchical data model but this model is first time developed by CODASYL network although initial network database was Honeywell IDS but it was not standardize at that time as network model

Similar Essays

Fundamentals Of Database Design Essay

2210 words - 9 pages Design Methodologies Fundamentals of Database Often as a company grows there may be a demand , because their data volumes increases and it is difficult to store their data physically in papers .They needed effective secure, and easy ways to do this. To counteract this companies came up with file systems which had their own constraints .So they went for the latest used solution now available the database. Temenos a technology manager cited

Access Is An Excellent Tool Essay

638 words - 3 pages this essay are shuffled. If you want to read the essay in it's proper state, click here. 1 1 There are a number of advantages to the relational database model, such as built in multilevel integrity, logical and physical data independence from database ..."Logical Database Design.(English) 69% match : root : Sciences : Computer Science" . . . Logical Database Design. Note! The sentences in this essay are shuffled. If you want to read the essay in

Database Management System Essay

2000 words - 8 pages •separation of data and metadata •flexibility of changing metadata •program-data independence Data access language •standardized SQL •ad-hoc query formulation -easy System development •less effort required •concentration on logical level design is enough •components to organize data storageprocess queries, manage concurrent access, recovery from failures, manage access control are all available DATA MODEL Collection

The Changing Role Of The Database Administrator

1145 words - 5 pages ?', Database Programming & Design. July 1995, p. 32-37.Shelly, Cashman, Waggoner., Complete Computer Concepts and Programming in Microsoft Basic., Massachusetts. Boyd & Frazer Publishing Company, 1992.Sipolt, Michael J., 'An Object Lesson In Management (Excerpt from 'The Object- Oriented Enterprise')', Datamation. July 1, 1995, p. 51-54.Wong, William, 'Database Integration', Network VAR, Nov 1995, p. 31-37.