Design should accurately translate the results of analysis into a specification that is user-friendly, optimized, buildable and maintainable. Design builds directly upon the deliverables from analysis. This course discusses the phases and deliverables of database design. It presents a step-by-step process for designing a database based on business requirements.
The workshop divides design into Preliminary Design, High Level Design and Detailed Level Design. Preliminary Design accomplishes the transition from analysis and determines the technical architecture of the database. It also decides what data will reside on which processors. High Level Design is design which applies few compromises. Initially, the data model is prototyped as close to the structure of the logical data model as possible. Integrity of the data is a main concern. Detailed Level Design is design from the viewpoint of the builder. It optimizes the data and applies more aggressive compromises.
It uses the same case study as Logical Data Modeling. You complete the course with experience in design.
The workshop provides a full discussion of and experience with logical data base design. Three types of trade-offs to the data will be applied – technology, safe and aggressive tradeoffs. You will learn how to apply safe and aggressive trade-offs for optimizing the data. Safe trade-offs optimize the data without compromising integrity and redundancy. Aggressive trade-offs optimize the data while providing some compromise of integrity or redundancy. Technology trade-offs use overhead features of the DBMS.
The workshop also defines object orientation. You will learn how to get the most out of your analysis and design deliverables when doing object design.
The seminar also shows how to divide design into layers: Presentation, Data, Function and Interface. This is important for client-server design. Presentation deals with the human interface and its supporting modules. Data deals with data design, data access, integrity modules and conversion to the target DBMS. Function deals with processing and with complex and sophisticated calculations and decisions; it consists mostly of modules. Interface deals with batch and on-line exchanges of data, and the modules that support this.
This workshop offers a design approach that will work with all forms of development: host-based, PC-based, client-server and object-oriented.
Upon successful completion of this course, the student will be able to understand:
- A step by step way to do design
- The use of logical model in design
- How to do a design that meets business requirements
- How to optimize (de-normalize) data
- How to design screens and reports
- How and when to prototype
- The different forms of prototyping
- What design must deliver to implementation
To get the most out of design, it is advisable that you have an understanding of analysis. This can be achieved by attending our Logical Data Modeling workshop or having equivalent experience.