This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: 1. What is the major goal(s) of a database designer? Discuss two ways covered in class or identified by your readings that today’s database designers achieve this goal. The goal of the design process is to achieve minimum redundancy (storing the same data over and over again), a minimum database size and protection against errors that might occur. Eliminating redundancy and protecting against user errors are done through normalization. This means applying a set of principles in order to organize existing data into logical entities. These will be represented as tables connected through relations. To achieve a robust table organization, you must pass data through the three steps of normalization. Starting from the not-normalized information, each applied rule will shape the organization of your database. Before throwing yourself on the computer to try and create something, take some time to gather and analyze all data you plan to work with in your web application. This is what normalization is all about. Once information is normalized, you can move on to building the actual database. Another thing that will minimize anomalies is to remember that when you create a table in the database, you must also define each of the columns it contains. Although you can also add columns later, it is recommended that all columns identified during the normalization process should be created at the same time with the table. For each column in a table, the following elements must be specified: 1. The column name – this identifies a column, and it must be unique for the table it belongs to, as you will use it in queries to retrieve specific attributes. Columns with the same name can exist in the same database, but in different tables. 2. The column's data type – this establishes what type of data a certain column can contain. The types allowed for various purposes vary between different implementations of database software. However, a few basic types exist in all database languages: of database software....
View Full Document
- Spring '10
- Sales, Switchboard