Relational Database Design A Practical Approach
In this course, students will design and create a relational database.
PŘEDPOKLADY
Access 2007 - Level 1
Nahoru
CÍLOVÁ SKUPINA
Individuals who are able to write simple queries or run queries that someone else has designed.
TÉMATA KURZU
Upon successful completion of this course, students will be able to:
- analyze client requirements.
- create a preliminary design.
- implement the database design.
- generate reports.
- customize a database.
Nahoru
OSNOVA KURZU
1 - ANALYZING CLIENT REQUIREMENTS
Analyze Current Data Storage Systems
Identify New Client Requirements
Determine the Required Data Fields
Group Fields into Tables
Identify Key Fields
2 - CREATING A PRELIMINARY DESIGN
Create a Preliminary Entity Relationship Diagram
Apply the First Normal Form
Apply the Second Normal Form
Apply the Third Normal Form
Apply the Higher Normal Forms
Denormalize Tables
Incorporate Client Feedback
3 - IMPLEMENTING THE DATABASE DESIGN
Translate Business Rules into Constraints
Create Tables
Create Indexes
4 - GENERATING REPORTS
Manipulate Data
Generate Reports Using Conditions
Generate Reports from Multiple Tables
Generate Summary Reports
Create Views
5 - CUSTOMIZING A DATABASE
Modify Constraints
Modify Fields
Modify Tables
Aktuální osnova kurzu se může lišit v závislosti na pobočce, která ho nabízí. Více informací vám poskytnou naši obchodní zástupci.
Nahoru
SOUVISEJÍCÍ
