Courses-Level-2G

Course Code:ITC21013
Course Title:Database Management System
Credit Value:3 Credits
Notional Hours:
TheoryPracticalIndependent Learning
303090
Course ObjectiveProvide adequate knowledge on the data representation models and data
manipulation to design and implement database systems.
Intended Learning outcome:
  • define the various types of data representation model
  • compare the organization of files and database
  • construct models for a given real-world requirement
  • identify suitable normalized table format for relational design
  • apply data definition language to implement database
  • make use of manipulation language to manage the database
Contents:
  • Introduction to database: File-based system and its limitations, database management system and advantages, database users: administrator, designer, developer, end-user; Database architecture: Three-level architecture, external level, conceptual level, internal level, schemas, mapping, client-server architecture
  • Relational data model: relations, integrity constraint, entity integrity, referential integrity, key, foreign key, relational database schema; Relational algebra: unary operation, set operation, join operation, division operation, aggregation and grouping, selection, projection set operation; 
  • ER model: Entity type – strong & week, relationship, set, attribute- simple, composite, single value, multi-value, and key, one-to-one, one-to-many, many-to-many; Normalization: the purpose of normalization, data anomalies – insertion , deletion, modification, functional dependencies, 1NF, 2NF, 3NF; 
  • Data definition language, data manipulation language, implement the concept using SQL
Teaching/Learning Methods:Classroom lectures, laboratory practical, tutorial discussions, and blended learning mode.
Assessment Strategy
  • In-course Assessments —————————————30%
  • End-of-course Examination ———————————-70%
Recommended Readings
  • Data, C.J., (2003). An introduction to Database systems. 8th Ed. Pearson.
  • Data, C.J., (2019). Database Design and Relational Theory. 2nd Ed. Apress.
  • Thomas, C. and Carolin, B., (2014). Database systems: A practical approach to design, implementation and management. 6th Ed. Pearson.
  • Raghu, R., (2002). Database management system. 3rd Ed. McGraw-Hill
  •  Elmasri, R. and Navatha. S., (2017). Fundamentals of database system. 7th Ed. Pearson India.
Course Code: ITC22013
Course Title: Web Application Development
Credit Value: 3 Credits
Notional Hours:
 Theory Practical Independent Learning
30 30 90
Course Objective Provide programming skills on the web page
development techniques by integrating modern tools and databases to achieve
said application through web and Internet.
Intended Learning outcome:
  • explain the fundamental concepts of the Internet and the world wide web
  • define the operations of servers in the web-based application
  • make use of basic tools to develop simple web pages
  • develop application by linking database with the web
  • apply styles, dynamic programming concepts into the web design
  • explain client-side and server-side programming
Contents:
  • Introduction: basics of the network, the concept of Internet, protocols, web servers, operation of world wide web, type of web pages: dynamic and static, introducing sample web application
  • Web page components and user interface design using standard web page design languages: font, colour, table, style, buttons, images, frames, link, the structure of Cascading Style Sheet CSS; Introduction to languages: PHP, Database connection with web pages using PHP, Javascript, Ajax
  • Introduction to client-side programming and server-side programming
  • Develop web-based application for real-world problem
  • Introduction to content-based management system and web page application development hands on training.
Teaching/Learning Methods: Classroom lectures, laboratory practical, tutorial discussions, and blended learning mode.
Assessment Strategy
  • In-course Assessments —————————————30%
  • End-of-course Examination ———————————-70%
Recommended Readings
  • Randy, C. and Ricardo, H., (2017). Fundamentals of web development. 2nd Ed. Pearson.
  • Robin, N., (2018). Learning PHP, MySQL & JavaScript. 5th Ed. O’Reilly Media.
  • Andy, W., (2018). WordPress for Beginners 2019: A Visual Step-by-Step Guide to Mastering WordPress.
  • Jon, D., (2014). Web Design with HTML, CSS, JavaScript and jQuery Set. Wiley.
  • Jon. D., (2011). HTML and CSS: Design and Build Websites. John Wiley & Sons.