Page 8 - Database-En-V3

Contents :

The overall objective of the training program ....................................................... 3
Course Sub-goals................................................................................................. 3
Program training plan.......................................................................................... 3
Components of the training program ................................................................... 3
Training methods ................................................................................................ 4
Database definition ............................................................................................. 6
Examples of using software that includes databases ............................................10
Advantages of using databases ...........................................................................10
The advantages of database as declared below: ..................................................11
Database design.................................................................................................13

What is good database design?...........................................................................13

I. Design process ................................................................................................13

II. Relationships between tables..........................................................................17

Types of relationships.........................................................................................17

III. Normalization rules .......................................................................................19
Database Administrators: ...................................................................................20

1. System Analyst: .......................................................................20

2. Database Designer: ..................................................................20

3. Database Developer: ................................................................20

4. Programmer: ...........................................................................20

5. Database Manager: ..................................................................20

6. Users: .......................................................................................20

7. Operators: ...............................................................................20

8. Maintenance ............................................................................20

Scientific background: ........................................................................................22

Database management systems software............................................................22
What is database management software (DBMS)?...............................................22
Access 2019 .......................................................................................................22
The most important features of Access: ..............................................................23
Steps to run the ACCESS program:.......................................................................24
The main window of Access ................................................................................25
Steps to create a new database ..........................................................................29
The main window of the Access program ............................................................30
Objectives of the training day: ............................................................................34
Field Properties: .................................................................................................41
Then the primary key of the table is determined:.................................................43

1 Training unit in the field of technological information - at the Supreme Council of Universities © Intellectual property rights 2024