Database design process

894 Words2 Pages
bulb-icon

Recommended: Research paper on normalization in dbms

Abstract
Database Systems has a practical, hands-on approach that makes it uniquely suited to providing a strong foundation in good database design practice. Database design is more art than science. While it's true that a properly designed database should follow the normal forms and the relational model, you still have to come up with a design that reflects the business you are trying to model. This paper shows describes design process of database project.
The importance of Completing the Design Process
An important point to keep in mind is that the level of structural integrity and data integrity is in direct proportion to how thoroughly the design process is followed. The less time spent on the design process, the greater the risk of encountering problems with the database. While thoroughly following the database design process may not eliminate all of the problems you may encounter when designing a database, it will greatly help to minimize them. Also in an RDBMS software program a well-designed database is easier to implement than a poorly designed database. (Michael J. Hernandez, 1996)
Key database Design Concepts
Before a design effort can proceed full speed ahead, the designer must first take time to understand the business. Understanding the business involves understanding the entities, data, and rules within an organization, and then converting these attributes of the business into a business model. Then, the designer must have a solid comprehension of the proposed database model. Finally, the designer will convert the business model into a database model, using a design methodology, whether automated or a manual process.
(Ryan Stephens & Ronald Plew, 2002)
General Design Process
Following table list general steps of database design
Step Description
1 Requirements collection and analysis

2 Conceptual database design

3 Choice of a DBMS

4 Data model mapping (also called logical database design)

5 Physical database design

6 Database system implementation

(Elmasri, Ramez, & Navathe, Shamkant B., 1994)
Creating the application is the last step¡ªnot the first! Many developers take an idea for an application, bu...

... middle of paper ...

... levels of normalization, but the primary levels are the first, second, and third normal forms. Each level has a rule or two that must be followed. Following all of the rules will help ensure that your database is well organized and flexible.
To take an idea from inception through to fruition, you should follow a design process. This process essentially says "think before you act." Discuss rules, requirements, and objectives, and then create the final version of your normalized tables.

Reference

1. Elmasri, Ramez, & Navathe, Shamkant B., Fundamentals of Database Systems, Second Edition, Addison-Wesley Publishing Company, 1994, ISBN 0-8053-1748-1, pages 450-452.), retrieved from website http://www.ibiblio.org/faint/finosaur/db/ , Feb 06, 2005
2. Michael J. Hernandez, Database Design For Mere Mortals, Chapter 4, 1996, retrieved from UOP resource safari Tech Books Online website, Feb 06,2005
3. Ryan Stephens & Ronald Plew, Key database design concepts, 2002, retrieved from website http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci812028,00.html, Feb 06, 2005

Show More
Related

  • Adolf Hitler's Goal: World Domination

    1568 Words  | 4 Pages

    Oracle ThinkQuest. Oracle Education Foundation, 04 Jun 2010. Web.

    Read More

  • Assignment 282: Database Scenarios

    1012 Words  | 3 Pages

    Now click the “ENTER” key on your keyboard, on your computer is operating in ‘Safe Mode’.

    Read More

  • Financial Analysis of Oracle Corp

    2599 Words  | 6 Pages

    In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system. The original project on the relational database system was for the government (Central Intelligence Agency) and was dubbed ‘Oracle.’ They thought this would be appropriate because the meaning of Oracle is source of wisdom.

    Read More

  • American Greeting Project Summary

    2721 Words  | 6 Pages

    4. Create Prototypes. That is our focused problem how to improve the level of this process to meet the customers’ needs effectively. It is the key part in the whole American Greetings prototyping model. We will introduce the step in next chapter.

    Read More

  • Database Performance Tuning

    1067 Words  | 3 Pages

    The database application design can be improved in a number of ways as described below:

    Read More

  • Privacy and Security Issues in Data Mining

    1885 Words  | 4 Pages

    [7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.

    Read More

  • Traditional Organization and Learning Organization

    955 Words  | 2 Pages

    When the buzzword of business model was very active and reactive during the internet boom, many individuals did not understand the concept of the proper business model for the proper business (Magretta, 2002). When not utilizing the right type of model for the organization, the model will be misused and distorted (Magretta, 2002). Understanding the traditional organization and learning organization, will allow an organization to determine which time of organization they desire the most.

    Read More

  • Database

    761 Words  | 2 Pages

    Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.

    Read More

  • Normalization and Integrity

    1055 Words  | 3 Pages

    Inconsistently storing organization data creates a lot of issues, a poor database design can cause security, integrity and normalization related issues. Majority of these issues are due to redundancy and weak data integrity and irregular storage, it is an ongoing challenge for every organization and it is important for organization and DBA to build logical, conceptual and efficient design for database. In today’s complex database systems Normalization, Data Integrity and security plays a key role. Normalization as design approach helps to minimize data redundancy and optimizes data structure by systematically and properly placing data in to appropriate groupings, a successful normalize designed follows “First Normalization Flow”, “Second Normalization Flow” and “Third Normalization flow”. Data integrity helps to increase accuracy and consistency of data over its entire life cycle, it also help keep track of database objects and ensure that each object is created, formatted and maintained properly. It is critical aspect of database design which involves “Database Structure Integrity” and “Semantic data Integrity”. Database Security is another high priority and critical issue for every organization, data breaches continue to dominate business and IT, building a secure system is as much important like Normalization and Data Integrity. Secure system helps to protect data from unauthorized users, data masking and data encryption are preferred technology used by DBA to protect data.

    Read More

  • Letter To Lorenzo Medici

    1091 Words  | 3 Pages

    Dear Lorenzo Medici, I Antonio da Sangallo the Younger, will love to take the opportunity to work with you for this offering you are having. I have constructed so many beautiful buildings you will like. Some of the buildings I have constructed are; St. Peter’s Basilica, Palazzo Farnese, Villa Madame, San Giovanni dei Fiorentini, Palazzo Baldassini,Fortezza da Basso, Cappella Paolina, Palazzo Sacchetti, Santo Spirito in Sassia and Santo Maria in Monserrato degli Spagnoli . You are probably wondering why I want to work with you , well the reason I would like to work with you is because you are giving out a huge offer or opportunity to work for your Villa and I am so interested in your job offering. I think my buildings will work just right for your new Villa.

    Read More

  • Oracle Databases

    1555 Words  | 4 Pages

    Oracle's relational databases represent a new and exciting database technology and philosophy on campus. As the Oracle development projects continue to impact on University applications, more and more users will realize the power and capabilities of relational database technology.

    Read More

  • The Concept of Ideation: Steps and Procedures

    587 Words  | 2 Pages

    The development of innovative products always arises from different steps and procedures. One of these procedures is ideation. What is ideation? The term ideation could be elucidated as the process of relating and forming new ideas by conceiving, generating, and implementing them (ideas). It is crucial to point out that it comprises of a several stages of intellectual cycles such as innovation, development, and actualization. According to (Cooper and Edgett, 2008), brainstorming is one of the best techniques of ideation because it provides a variety of ideas. Furthermore, brainstorming allows an individual to borrow from different people in order to have a perfect direction when implementing the idea. This paper discusses the ideation process, alternative concepts, and solutions in ideation and provides an overview of a concept on the iPhone 5C model.

    Read More

  • M1 Wireless Communication

    907 Words  | 2 Pages

    [1]- Ralph Stair, George Reynolds and Thomas Chesney. 2012. Fundamentals of Business information systems. 2nd edition: Cengage Learning EMEA.

    Read More

  • Kick Off Team Meeting

    705 Words  | 2 Pages

    The first step in creating

    Read More

  • database management system and information retrieval system

    1069 Words  | 3 Pages

    A database management system in the main software tool of the database management approach because it controls the creation, maintenance, and use of the database of an organization and its users. The three major functions of a database management system are first to create new database and database application. Second to maintain the quality of the data in an organized database. And last to use the database of an organization to provide the information that its end users need. An example of a database management approach in a banking information system. Note how the savings, checking and installment loan programs use a database management system to share a customer database. Note also that the database management system allows a user to make direct, ad hoc interrogations of the database without using application programs.

    Read More

More about Database design process

Open Document