Database Designing Made Easy

Database Designing Made Easy

by Admin · 0 comments · in Excel Programming

Do not let words like “database administrators” or “database architects” scare you into thinking that database designing is as intimidating as it sounds. The reality is that database designing ranges from being too simple to ultra complex. There are largely two types of database programs, one is at the simple end of the scale and these are flat line databases which are also called list managers or single file databases. These programs are as easy to learn as spreadsheets or word processing. If your needs for databases are limited to that of a class, a small organization, club or at home, then flat line database program is enough to meet all your requirements.

 

    Relational databases make things more complex. With relational databases you can create a range of databases ranging from demanding multi file systems to flat line structures. Whichever type of database you choose to use, the most important step is to use it to design your database structure carefully. The way you choose to structure your data will have an effect on every other action. The database designing will determine how easy it is to enter information into the database, its capacity to exclude duplicate records and trap inconsistencies and how well you can extract information out of the database.

 

     * Revising your Design- After entering input into database for designing, if you see the end result and decide that this is not what you want, you can revise your design with ease. For instance, if you have sorted a list of names by their initials and immediately realize that you have to sort the list alphabetically by the people's last names and not the initials, there is a simple way to revise this. You could do some manipulation using a database feature called 'string functions' or you could come up with a better table design for your data. Feed you data into this revised database structure and command the program to sort your list alphabetically by the last names of the persons mentioned. This time you are sure to get the correct order.

 

     * Further Refinement- You can further break down your data list structure. For instance, you can break your database structure further down to last names, initials, street address, phone numbers, email address etc. to structure and categorize it even further.

 

     * Create Useful Fields- In the previous instance, while the structure may look more complex, the data has been reduced to the simplest, most fragmented form that is easily sorted and categorized in a database field. If we are dealing with multi line business with more than one address, then it is more sensible to break the address field down into two sub fields i.e. address line 1 and address line 2. You would want an easy way to print address line 1 and address line 2 as separate lines when you want to post. So this division of field becomes useful when you want to get information out of your database.

  

 So database designing is very useful and easy to make.

Comments (0)

POST YOUR COMMENT

Code
Excelq.com doing business as a Service of Venttraffic Media Inc. Excel and other words on this site may be trademarks or registered trademarks of Microsoft Corporation. Microsoft Corporation is not connected in any way with this website, and makes no endorsement of the site or its related contents. All rights reserved. Website powered by Venttraffic Media Inc.