Course Code: IENG 2520
Academic Year: 2023-2024
Students gain a background in database design and normalization, an essential component of the business IT world today. Students study relation algebra and calculus and investigate how they strengthen the relational model. Students work with entity-relationship diagrams (ERD) to learn and implement the basic database design. Using SQL, students apply the design principles to actually create and develop a working database. Students integrate theoretical knowledge with practical programming skills to implement a database. Students also use SQL commands to query single and multiple tables. Single and group functions are also used to enhance queries. Students employ subqueries to enhance data retrieval. Students learn to manipulate data to change the data in the database. Students investigate other database systems, hierarchical and network models. Student experience how indexing is used to increase performance in query retrieval.