{"id":890,"date":"2022-08-08T10:01:05","date_gmt":"2022-08-08T10:01:05","guid":{"rendered":"https:\/\/www.ict.jfn.ac.lk\/?page_id=890"},"modified":"2022-09-29T09:59:32","modified_gmt":"2022-09-29T09:59:32","slug":"level-2g","status":"publish","type":"page","link":"https:\/\/www.ict.jfn.ac.lk\/index.php\/level-2g\/","title":{"rendered":"Level – 2G"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

   Courses-Level-2G<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t<\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\tITC21013: Database Management System<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t
<\/colgroup>
Course Code:<\/td>ITC21013<\/span><\/td><\/tr>
Course Title:<\/td>Database Management System<\/span><\/td><\/tr>
Credit Value:<\/td>3 Credits<\/td><\/tr>
Notional Hours:<\/div><\/td>
Theory<\/td>Practical<\/td>Independent Learning<\/td><\/tr>
30<\/td>30<\/td>90<\/td><\/tr>
Course Objective<\/td>Provide adequate knowledge on the data representation models and data
manipulation to design and implement database systems.<\/span><\/td><\/tr>
Intended Learning outcome:<\/td>
  • define the various types of data representation model<\/span><\/li>
  • compare the organization of files and database<\/span><\/li>
  • construct models for a given real-world requirement<\/span><\/li>
  • identify suitable normalized table format for relational design<\/span><\/li>
  • apply data definition language to implement database<\/span><\/li>
  • make use of manipulation language to manage the database<\/span><\/li><\/ul><\/div><\/td><\/tr>
Contents:<\/td>
  • 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<\/span><\/li>
  • 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;\u00a0<\/span><\/li>
  • ER model: Entity type \u2013 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 \u2013 insertion , deletion, modification, functional dependencies, 1NF, 2NF, 3NF;\u00a0<\/span><\/li>
  • Data definition language, data manipulation language, implement the concept using SQL<\/span><\/li><\/ul><\/div><\/td><\/tr>
Teaching\/Learning Methods:<\/td>Classroom lectures, laboratory practical, tutorial discussions, and blended learning mode.<\/td><\/tr>
Assessment Strategy<\/b><\/td>
  • In-course Assessments \u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u201430%<\/li>
  • End-of-course Examination \u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-70%<\/li><\/ul><\/td><\/tr>
Recommended Readings<\/b><\/td>