Relational Database Design A Practical Approach هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

In this course, students will design and create a relational database.

Course Outline

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

Target Audience: Inpiduals who are able to write simple queries or run queries that someone else has designed.