L AN
Local area network
W a N
Wide area network
Should you use sample database design
No stock designs may not meet your criteria and will cause you problems in the end
What are the two basic problems in data base design
Application problems and data problems
What are application problems
Application problems
- problematic data entry
- confusing menus, toolbars, dialog boxes
- tedious task sequences
How do data base problems usually happen
Inexperience,
- poor application design methodology
- knows too little about the database software
What are some examples of data problems
Data problems include
- missing, incorrect, mismatched data, and
- inaccurate information
What creates most data base problem
Poor design
What are the three phases and the design process
- logical design,
- physical implementation,
- application development
What is logical design
Logical design is the first phase
- determine and define or establish…
- tables and fields,
- primary and foreign keys,
- table relationships,
- the various levels of data integrity
What is physical implementation
Physical implementation is the second phase
- create the tables,
- establish key fields and table relationships,
- use proper tools to implement levels of data integrity
What is application development
Application development is the third phase.
-create an application that allows users to interact with the data stored in the database
What are the stages in the application development process
Determining end-user tasks
- appropriate sequences,
- info requirements for report output,
- creating a menu system for navigating the application
Why is logical design important
Logical design ensures that you make conscious, methodical, clear, and informed decisions concerning the structure of your database
