|
|
||||||
At the heart of most pieces of business software is a database - a place in which data is stored, hopefully
in an organised and structured manner, and from which data is retrieved. Database design is about making
sure that your data is easily accessed by those who need it, and secured from those who don't!
Understanding the way in which data is used, and how segments of data relate to each other, provides the insight into the required design of a database, for it this information that allows the developer to ensure that the database performs efficiently and effectively.
| Database design | |||||||||
|
About database designMicrosoft's "Access" is probably one of the most widely used database packages in the world. Featuring in-built programming capabilities, and user-friendly design tools, it makes an ideal choice for many home and small business users. More powerful, and more complex, is Microsoft's SQL Server - geared towards larger multi-users systems and high volumes of data. And sitting between the two is the Microsoft Desktop Engine (MSDE).
The best choice of database for your application will depend on the details of what you need to achieve,
the volume of data you need to store and process, and the levels of security you need to enforce.
|
|
|
|
|
|
back
top of page
|
|||