Database Management SWEN 3410

Course description:

The course introduces relational database management systems as a class of software systems. Prepares students to be sophisticated users of database management systems. The course covers design theory, query language and performance/tuning issues. Topics include relational Algebra, SQL, stored procedures, user-defined functions, cursors, embedded SQL programs, client-server interfaces, entity-relationship diagrams, normalization, B-trees, concurrency, transactions, database security, constraints, object-relational DBMSs, specialized engines such as spatial, text, XML conversion and time series.

Course Aims:

Upon completion of the course, students will be able to:
  • To provide students a clear and complete description about the characteristics of Database systems. 
  • Understanding data modeling and database design. 
  • To understand the languages and facilities provided by database systems.
  • To understand the implementation of database systems.

Course outcomes:

    A-Knowledge and Understanding: 
    • Be able to understand the principles and techniques of a number of research areas such as databases, DSS, information management, project engagement, data mining. 
    • Be able to design a database as free-standing applications. 
    • Be able to invoke the database applications with the World-Wide Web browser. 
    B- Intellectual: 
    • Be able to contribute in design and implement software systems in the field of decision making and strategic planning.
    • Be able to design a database as free-standing applications. 
    • Be able to invoke the database applications with the World-Wide Web browser. 
    C- Practical: 
    • Be able to design a database as free-standing applications. 
    • Be able to invoke the database applications with the World-Wide Web browser