Course Description
This course serves as an introduction to database systems, providing students with a strong understanding of fundamental concepts, practical design techniques, and the use of relational database management systems (RDBMS). It lays the groundwork for further exploration and advanced studies in the field of databases.Course Summary
The Introduction to Database Systems course equips students with the necessary knowledge and skills to navigate the world of database systems. Through a combination of theoretical concepts and hands-on practice, students will gain proficiency in designing and utilizing RDBMS. The course covers fundamental topics such as database concepts, the entity-relationship (ER) model, relational data modeling, integrity constraints, normalization theory, logical database design, and the use of SQL for querying and manipulating data. Additionally, students will learn about transaction management and concurrency control, essential aspects of maintaining data consistency and managing multiple user interactions.
The course Data Communication and Networks (CY 164) focuses on the fundamentals of data communication networks. The key goal is to give some insight into the rationale of why networks are structured the way they are today and to understand the issues facing the designers of next-generation data networks. Much of the course focuses on network algorithms and their performance. Students are expected to have a strong mathematical background. Topics to be discussed include: layered network architecture, Link Layer protocols, high-speed packet switching, Local Area Networks, and Wide Area Networking issues, including routing and flow control.
This course provides students to understand the fundamental
concepts of computer networking and communications make use of IEEE standards
in the construction of LAN, build the skills of subnetting and supernetting, explain
the concepts of protocols of Transport Layer, QoS and Congestion control
mechanisms and demonstrate different protocols of Application Layer.