Free

Database Design - Term Paper Example

Summary

The paper "Database Design" is a brilliant example of a term paper on information technology. Business Rules are employed in the system design process in order to define: Attributes, Entities, Relationships, Constraints. It is important to keep the business rules straightforward, easy to comprehend so that could be easily understood by different individuals…

Download full paper File format: .doc, available for editing

GRAB THE BEST PAPER95.3% of users find it useful

Read Text Preview

Subject: Information Technology
Type: Term Paper
Level: College
Pages: 1 (250 words)
Downloads: 1

Extract of sample "Database Design"

The paper "Database Design" is a brilliant example of a term paper on information technology.

Business rules and their importance to Designers
Business Rules are employed in the system design process in order to define: Attributes, Entities, Relationships, Constraints.
It is important to keep the business rules straightforward, easy to comprehend so that could be easily understood by different individuals. Business rules should always be in writing and they must be updated. Business rules are important to designers since they allow the creator to develop rules for relationship participation as well as constraints and also to create an accurate data model. They also help the creators to know and understand business processes, nature, and scope of the data. They are a tool of communication between the users and the creators, and they also prove helpful in standardizing the organization’s view of the data (Jesdisciple, 2010).

The function of the data dictionary in database design
A data dictionary is the warehouse of all maintenance and design information that is needed for a database. It contains all the documentation and specification and serves as a reference guidebook of a particular database (Allentech, 2010).
These particulars should be included in a data dictionary:
- Entity Relationship diagram, Logical data model or notes.
- Definitions of entity and attribute definitions, data domain, data type, descriptions.
- Relationships of entities, primary & foreign keys, descriptions, and cardinalities
- Domain constraints and data domain definitions
- Any supplementary information regarding the design, planned use, and administration of the database
- Information regarding user accessibility; the way the user has the right to access and modify the database.

Factors important in a DBMS software selection
According to Whitehorn (2010) the process of selection of DBMS depends on the following critical factors:
- Project size
- Technical competency of the DBMS
- The number of concurrent users of the DBMS Read More

CHECK THESE SAMPLES OF Database Design

Database Development Process

As such, it is typically a part of the software development life cycle, and its typical components are shown in the diagram below and enumerated as under:Feasibility study and requirement analysis - Database Design- Database implement- Data and application conversion- Testing and validation- Monitoring and maintenanceDatabase development is clearly a process that requires careful planning commensurate with its complexity.... … The paper "database Development Process" is an outstanding example of an essay on information technology....

1 Pages (250 words) Essay

Creating a Reliable Database for Small Business Enterprises

The logical Database Design will rely on different entities depending on what the café provides most to its clients.... Small business enterprises need to create and design reliable databases for better services and loss minimization.... Small business enterprises need to create and design reliable databases for better services and loss minimization.... For instance, if a small businessman runs a chain of hotels or has a café offering both take in and take away foods, it is prudent for them to design a database for his products (Reid 13)....

1 Pages (250 words) Essay

What Are the Advantages and Disadvantages of Database

A Chinese by the name Chen hard proposed an (ER), entity relationship, a model used for Database Design, which is conceptually a data mode.... However, this can be best done with the aid of a system structured to procedurally collect information (data) stored a s a soft copy within a computer system, database is able to store both large and small information/ records which should be easily accessible with options of adding or removing the information content....

9 Pages (2250 words) Essay

How Businesses Use DBMS Model

for the businesses to use these various DBMS effectively, the software comes with a driver known as Open database(ODDBC) that allows it to integrate with the other databases(OpenLink, 2013).... However, a good database Management System must also co-exist with a proper business plan and the companies must expect their profits in the long run but not immediately.... The relational data model provides a direct method to specify data as well as queries where users state directly the information contained in the database and the type of information that need for it....

6 Pages (1500 words)

Mdrink Ltd Business Re-engineering

The paper discusses the customer relationship database and lastly project plan and budget.... … The paper "Mdrink Ltd Business Re-engineering " is a perfect example of a business case study.... Mdrink Ltd is the leading soft drink producer in Australia having over 4 deports across the country with over 30 nonalcoholic brands....

11 Pages (2750 words) Case Study

Database Management Systems

… The paper "database Management Systems" is a wonderful example of an assignment on business.... The paper "database Management Systems" is a wonderful example of an assignment on business.... It is therefore us to combine the various definition and explanations to come up with a concrete understanding of this concept in the database.... The first definition is that a data model can be defined as a combination of concepts to clearly explain the structure of a database, the methods involved in manipulating these structures, and procedures and instructions that must be followed in a database (Watt and Navathe, 2014)....

10 Pages (2500 words) Assignment

Advanced Accounting Information System

… The paper “Advanced Accounting Information System ” is an excellent example of a case study on finance & accounting.... With all of Trigon Corporation's success, it is difficult to identify its weakness.... Their weakness lies in their product seasonality.... Trigon's customers have a huge influence on their operations....

11 Pages (2750 words) Case Study