Course Description
This course addresses the general definition of databases systems and their components. It also provides a definition of the relationship of database systems and other programs with the Management Information System. Scheduled to review the basic concepts of database management systems, such as the concept of the candidate fields (Candidate Keys) and (Primary Keys) and foreign (Foreign Keys) through the relational model. It explains the concept of reliability and also offers normalization, its benefits and how to activate it.
Course Aims
- Determine the concept of databases.
- Know the advantages and disadvantages of databases.
- Know the different types of databases.
- Know the basic components of the environment databases.
- Define the various schemes of the relational model
- Draw Display modeling Being Entity Relationship Modeling (ERM)
- Know relational model RM (Relational Model)
- Converse ERM to RM
- Identify constraints (Constraints) on the master key and foreign key
- clarify the impact of functional Dependencies
- clarify the process of normalization (Normalization).
- Create a database using SQL structured query language Structured Query Language
Course Contents:
- Understand the basic principles of databases
- Knowledge of the different areas of databases and applications
- Identify database components and activation of different tables
- Knowledge of the tools and techniques used in the development of database systems.
- Identify key and foreign keys
- Linking databases
- Apply the concept of normalization on databases
- Apply the previous theoretical concepts using Access
Course ID: MIS221
| Credit hours | Theory | Practical | Laboratory | Lecture | Studio | Contact hours | Pre-requisite | 4.50 | 4.50 | 4.5 | COMP141 |
|---|
