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
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.
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
Need Writing Help?
Get feedback on grammar, clarity, concision and logic instantly.Check your paper »
- Jay-Star Incorporated is a small machine shop located in Lexington, Kentucky. There are only seven employees that actually work on the shop floor. Jay-Star produces metal core and distributes that core to various aerospace manufacturers. There are three different types of core that Jay-Star produces: Square Cell, Hexagonal Cell, and Beneflex Cell. Each of them can be produced using different materials from various shipping companies. The employees take these materials from the shipping company, produce the product, and then deliver the finished product to the aerospace manufacturer (customer).... [tags: SQL Database]
1064 words (3 pages)
- In the web space where vast amounts of data is processed and collected, it is typical to store this information in a database. A common form of database is an RDBMS (Relational Database Management System). The act of retrieving and/or storing data to or from an RDBMS is called a transaction (Connolly and Begg, 2014). Connoly and Begg go on to outline the process in which these transactions are applied, by way of a COMMIT or ROLLBACK SQL statement, which are also written to a transaction log and may be used in the event of a systems failure to restore the database to a point prior to the failure.... [tags: SQL, Database, Relational model]
1079 words (3.1 pages)
- Databases and Communications Today, data is the most important of our life. Different companies handle a large number of data. The success of this or that business strongly depends on database arrangement and communication means, Database arrangement and communication are in the high demand among all organizations. The database and communication technologies are closely interrelated. The accessibility of database depends on used communication technologies. For instance, the employees may access the database not only from their workplaces but also from different places and use different communication technologies, including mobile phones, the internet mailing programs, e... [tags: Data management, Database, Media technology]
931 words (2.7 pages)
- 1.0 DBA Roles: DBA plays important role in every organization, they are the core part of Technology Team, based on Organization DBA roles vary but majority of their role are very critical due to impact, Architect, Quality Analyst, System Analyst and Developers everyone has to work with DBA during different development life cycles. DBA skills are hard to find majority of organization prefer DBA which are certified, and certification for DBA are hard to achieve. Organization Expectation from DBA: - DBA should have good understanding of Database and its tools.... [tags: Database Administration Essays]
941 words (2.7 pages)
- Evolution of data model The evolution of data model was traced back in 1960s when the first generation of data model – File system model was introduced. File system used to strictly maintain the records and it does not have relationship between the tables. As the requirement to for managing data evolve, in 1970s, hierarchical and network model were used. These data model handle the relationship between the tables and conceptually simple. However, it still using navigational system and complex in implementation.... [tags: Database normalization, Relational model]
1034 words (3 pages)
- ... Placing the reconfigurable platform near the device’s memory further reduces the processing time. Combination of all these three types of database systems described above gives us the “Hybrid Database System (HYBDBS)” that harnesses the power of all three. The design of a Hybrid Database System with Hybrid DB-server as its core component is shown, as provided in the research paper. It differs from standard DB systems in that it has a “Routines Repository” that stores database operators as hardware and software libraries, services and metadata.... [tags: disc resident databases, main memory]
655 words (1.9 pages)
- 4D Database System In the company I work in the program we use was developed specifically for our company. In land development, there are a number of factors that need to be taken in consideration to keep track of lots and blocks within different subdivisions. As well as lots being bought and sold to companies and individuals. The database system we use is called Ginger, a custom database designed to achieve the following objectives for our company: 1. Replace our old database. 2. Combine date from the old database.... [tags: Database Software Data]
1027 words (2.9 pages)
- Databases, Forms, and Reports This paper will discuss databases, forms and reports. Why has the use of databases increased dramatically. What factors should be considered when designing a database and why. How would you go about designing forms and reports from scratch. In conclusion, a summation will be given along with closing thoughts. Database Usage A database is an organized collection of information or data. It is a collection of organized information in which a computer can easily select and display different fields of data.... [tags: Database Organization Design Essays]
843 words (2.4 pages)
- Database Design Scenario Currently a school uses a non-computerised database system to store the following information about its students: roll class, surname, first name, guardian's name, address, student's date of birth, gender, sport house, emergency-contact telephone number, mailing name, list of subjects offered, and subjects in which the student is enrolled. The system takes up a large amount of space, has many duplicated entries some of these with mistakes and it is time consuming to search.... [tags: essays research papers]
1114 words (3.2 pages)
- In this paper I will be discussing the differences and similarities of the three database models we have talked about in class the Entity-Relationship, Object model, and the UML modeling. First let’s look at the definition of the three models. The Entity- Relationship Model is used to visually represent data objects and is used for database design. It is easy to understand which makes it easier to communicate the design to the end user. The form used in the ER model can easily be transformed into relational tables.... [tags: essays research papers]
454 words (1.3 pages)