Databases

  • College of Management & Technology |
  • English

Description

This course introduces the fundamental concepts necessary for the design, use, and implementation of database systems. The course emphasizes on the relational data model. The entity-relationship model is used for conceptual design and the SQL is used for physical design.

Program

Marketing and International Business

Objectives

  • •Introduce the fundamentals of database (DB) and database management systems (DBMS).rn•Explain the database system development process.rn•Provide the students with the fundamentals of data modeling.rn•Provide in-depth knowledge of structured query language (SQL) and how it can be used to create and manipulate databases.rn•Train the student on designing and implementing relational database using MS Access software.rn

Textbook

Data will be available soon!

Course Content

content serial Description
1Introduction to the database technology and its environment
2Database development process
3The Entity-Relationship (E-R) model
4The Entity-Relationship (E-R) model- continued
5The relational model
6Transforming ER model into relational model
77th week Exam
8Structured Query Language (SQL)
9SQL – DDL, DML and DCL
10SQL – more on Select statements
11Normalization
12Active database and triggers
13Data and database administration
14Client/server databases
15Revision
16Final Exam
1Introduction to the database technology and its environment
2Database development process
3The Entity-Relationship (E-R) model
4The Entity-Relationship (E-R) model- continued
5The relational model
6Transforming ER model into relational model
77th week Exam
8Structured Query Language (SQL)
9SQL – DDL, DML and DCL
10SQL – more on Select statements
11Normalization
12Active database and triggers
13Data and database administration
14Client/server databases
15Revision
16Final Exam
1Introduction to the database technology and its environment
2Database development process
3The Entity-Relationship (E-R) model
4The Entity-Relationship (E-R) model- continued
5The relational model
6Transforming ER model into relational model
77th week Exam
8Structured Query Language (SQL)
9SQL – DDL, DML and DCL
10SQL – more on Select statements
11Normalization
12Active database and triggers
13Data and database administration
14Client/server databases
15Revision
16Final Exam
1Introduction to the database technology and its environment
2Database development process
3The Entity-Relationship (E-R) model
4The Entity-Relationship (E-R) model- continued
5The relational model
6Transforming ER model into relational model
77th week Exam
8Structured Query Language (SQL)
9SQL – DDL, DML and DCL
10SQL – more on Select statements
11Normalization
12Active database and triggers
13Data and database administration
14Client/server databases
15Revision
16Final Exam

Markets and Career

  • Generation, transmission, distribution and utilization of electrical power for public and private sectors to secure both continuous and emergency demands.
  • Electrical power feeding for civil and military marine and aviation utilities.
  • Electrical works in construction engineering.

Start your application

Start The your journey to your new career.