Course
| code | IS273 |
| credit_hours | 3 |
| title | Database Systems |
| arbic title | |
| prequisites | CS143 |
| credit hours | 3 |
| Description/Outcomes | The course covers topics related to the analysis, design, and normalization of relational databases. Case studies are analyzed and discussed on each concept. Hands on implementation skills using SQL are covered including: data definition, data modification, SQL queries and subqueries. Implementation skills are practiced on ORACLE database management system. Advanced topics such as concurrent transactions are discussed along with related problems. Students also learn about additional Data Bases support for special data types such as Extensible Mark-Up Language (XML) documents. |
| arabic Description/Outcomes | |
| objectives | 1. Understand the fundamental concepts of database and database management systems, and historical roots of database
2. Understand conceptual database design using Entity-Relationship modeling.
3. Understand database design methodology using normalization
4. Design a database system for a real-world problem.
5. Learn about SQL data modification and data definitions.
6. Write SQL queries and sub queries.
7. Implement and verify a database system using ORACLE. |
| arabic objectives | |
| ref. books | 1. R. Elmasri and S. Navathe, Fundamentals of Database Systems, Benjamin-Cummings.
2. C. J. Date, An Introduction to Database Systems, Addison Wesley.
3. R. Ramakrishnan, J. Gehrke, Database Management Systems, McGraw-Hill. |
| arabic ref. books | |
| textbook | Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom, Database Systems: The Complete Book, Prentice Hall |
| arabic textbook | |
| objective set | |
| content set | |
| course file |
530_IS273_IS273.pdf |