{"id":72,"date":"2025-06-13T07:31:28","date_gmt":"2025-06-13T07:31:28","guid":{"rendered":"https:\/\/egco.org\/design\/?page_id=72"},"modified":"2025-10-14T10:52:58","modified_gmt":"2025-10-14T10:52:58","slug":"egco321-database-systems","status":"publish","type":"page","link":"https:\/\/egco.org\/design\/?page_id=72","title":{"rendered":"EGCO321 Database Systems"},"content":{"rendered":"
\n \n
\n \n \n
\n \n
\n \n
\n \n
\n
\n \n \n
\n \n
\n \n
\n \n \n

General Information<\/h2>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n \n
\n \n
\n
\n \n \n
\n \n
\n <\/span><\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n \n
\n \n
\n
\n \n \n
\n \n
\n \n \n
\n

Course Code:<\/strong><\/p>\n

Course Title:<\/strong><\/p>\n

Credit:<\/strong><\/p>\n

Prerequisites:<\/strong><\/p>\n

Course Type:<\/strong><\/p>\n

Time & Room:<\/strong><\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

\n
\n \n \n
\n \n
\n \n \n
\n

EGCO321<\/p>\n

Database Systems<\/p>\n

3 (3-0-6)<\/p>\n

EGCO221 Data Structures and Algorithms <\/p>\n

Core Course<\/p>\n

Friday, 9:00 – 12:00 Room No. 6273<\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

\n \n \n
\n \n
\n \n
\n \n
\n
\n \n \n
\n \n
\n \n
\n \n \n

Course Description<\/h2>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n \n
\n \n
\n
\n \n \n
\n \n
\n <\/span><\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n \n
\n \n
\n
\n \n \n
\n \n
\n \n \n
\n

Data model: entity-relationship, relational. Logical and Physical database design, Query Language, Data Dependencies and Normalization, Transaction, Crash Recovery, Concurrency control, Internet Databases. <\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

\n \n \n
\n \n
\n \n
\n \n
\n
\n \n \n
\n \n
\n \n
\n \n \n

Evaluation Method<\/h2>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n \n
\n \n
\n
\n \n \n
\n \n
\n <\/span><\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n \n
\n \n
\n
\n \n \n
\n \n
\n \n \n
\n

Assignments<\/p>\n

Project <\/p>\n

Midterm Exam<\/p>\n

Final Exam<\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

\n
\n \n \n
\n \n
\n \n \n
\n

50%<\/p>\n

10%<\/p>\n

20%<\/p>\n

20%<\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

\n \n \n
\n \n
\n \n
\n \n
\n
\n \n \n
\n \n
\n \n
\n \n \n

Tentative Schedule<\/h2>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n \n
\n \n
\n
\n \n \n
\n \n
\n <\/span><\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n \n
\n \n
\n
\n \n \n
\n \n
\n \n \n
\n

Week<\/strong><\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

\n
\n \n \n
\n \n
\n \n \n
\n

Topic<\/strong><\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

\n
\n \n \n
\n \n
\n \n \n
\n

Assignment\ufeff<\/span><\/strong><\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

\n \n
\n \n
\n
\n \n \n
\n \n
\n <\/span><\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n
\n \n
\n \n
\n
\n \n \n
\n \n
\n \n \n
\n

1<\/p>\n

2<\/p>\n

3<\/p>\n

4<\/p>\n

5<\/p>\n

6<\/p>\n

7<\/p>\n

8<\/p>\n

9<\/p>\n

10<\/p>\n

11<\/p>\n

12<\/p>\n

13<\/p>\n

14<\/p>\n

15<\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

\n
\n \n \n
\n \n
\n \n \n
\n

Introduction to Database Systems <\/p>\n

Relational Data Model<\/p>\n

Entity-Relationship Diagram (ERD)<\/p>\n

Functional Dependencies and Normalization<\/p>\n

Database Design <\/p>\n

Structured Query Language (SQL) Part I<\/p>\n

Structured Query Language (SQL) Part II<\/p>\n

Views and Indexes<\/p>\n

Stored Procedure and Trigger<\/p>\n

Transaction Processing<\/p>\n

Data Warehouse and Business Intelligence<\/p>\n

Data Visualization <\/p>\n

NoSQL: Basic Concepts<\/p>\n

NoSQL: Document-Based Model<\/p>\n

Project Presentation<\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

\n
\n \n \n
\n \n
\n \n \n
\n

 <\/p>\n

\n
\n <\/p>\n

Assignment 1 (5)<\/p>\n

\n
\n <\/p>\n

Assignemnt 2 (10)<\/p>\n

\n
\n <\/p>\n

Assignment 3 (10)<\/p>\n

\n
\n <\/p>\n

Assignment 4 (10)<\/p>\n

\n
\n <\/p>\n

\n
\n <\/p>\n

Assignment 5 (5)<\/p>\n

\n
\n <\/p>\n

Assignment 6 (10)<\/p>\n

\n
\n <\/p>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n

\n \n
\n \n
\n
\n \n \n
\n \n
\n <\/span><\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"

General Information Course Code: Course Title: Credit: Prerequisites: Course Type: Time & Room: EGCO321 Database Systems 3 (3-0-6) EGCO221 Data Structures and Algorithms  Core Course Friday, 9:00 – 12:00 Room No. 6273 Course Description Data model: entity-relationship, relational. Logical and Physical database design, Query Language, Data Dependencies and Normalization, Transaction, Crash Recovery, Concurrency control, Internet […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-templates\/full-width-page.php","meta":{"footnotes":""},"class_list":["post-72","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/egco.org\/design\/index.php?rest_route=\/wp\/v2\/pages\/72","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/egco.org\/design\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/egco.org\/design\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/egco.org\/design\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/egco.org\/design\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=72"}],"version-history":[{"count":20,"href":"https:\/\/egco.org\/design\/index.php?rest_route=\/wp\/v2\/pages\/72\/revisions"}],"predecessor-version":[{"id":715,"href":"https:\/\/egco.org\/design\/index.php?rest_route=\/wp\/v2\/pages\/72\/revisions\/715"}],"wp:attachment":[{"href":"https:\/\/egco.org\/design\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=72"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}