Database System and Management

1. Understand the core concepts of database management systems.
2. Design and implement relational databases using SQL.
3. Apply data modeling techniques to real-world problems.
4. Explain different data storage technologies and their characteristics.
5. Describe the fundamentals of XML and Web Services.
6. Understand the importance of data integrity and security.

13 weeks, about 105 hours in total. Yours will differ.

1. Week 1Module 1: Introduction to Database Management Systems

   • Unit 1: Basic Concepts of Database Management Systems · 5 hours

     Read the definition of a database management system.. Identify examples of database management systems.. Study the categories of database management systems..

2. Week 2Module 1: Introduction to Database Management Systems

   • Unit 2: Data Models · 5 hours

     Explain the notion of data models.. Identify common categories of data models.. Describe object-based logical models..

3. Week 3Module 1: Introduction to Database Management Systems

   • Unit 3: Instances and Schemes · 5 hours

     Describe Instances and Schemes.. Determine the link between instances and schemes.. Identify the classical categories of schemes..

   • Unit 4: Overall System Structure · 5 hours

     Explain the basis of partitioning databases.. List and describe the components of a data structure.. State the data structures required for physical system implementation..

4. Week 4Module 2: The Entity-Relationship Data Model

   • Unit 1: Entities and Entity Sets · 5 hours

     Describe an entity.. Specify the common types of entities.. Explain the concept of an entity set..

   • Unit 2: Relationships and Relationship Sets · 5 hours

     Define a relationship.. Describe the notion of relationship sets.. Explain the role of an entity..

5. Week 5Module 2: The Entity-Relationship Data Model

   • Unit 3: Structure of Relational Database · 5 hours

     Define a logical structure of a relational database by means of an E-R diagram.. List the components of an E-R diagram.. Explain the roles of each component of an E-R diagram..

   • Unit 4: The Relational Algebra · 5 hours

     Define relational algebra.. Mention six basic operations.. State the specific role of each operation..

6. Week 6Module 3: SQL and Integrity Constraints

   • Unit 1: Structured Query Language (SQL) Fundamentals · 5 hours

     Identify the structural components of SQL.. State the specific roles of a data definition language.. Describe the concept of an interactive data manipulation language..

   • Unit 2: SQL Expression · 5 hours

     State the components of an SQL expression.. Explain the key role of each component of an SQL expression.. Indicate specific examples of each of the clauses..

7. Week 7Module 3: SQL and Integrity Constraints

   • Unit 3: Database Modification · 5 hours

     Identify the common forms of database modification.. State the difference between tuples and relations.. Give the general syntax for the ‗Deleting, Inserting and Updating' databases..

   • Unit 4: Integrity Constraints · 5 hours

     Define domain constraints.. Show the link between main Constraints and Integrity Constraints.. Distinguish between referential integrity in the E-R Model and referential integrity in SQL..

8. Week 8Module 4: Computer Data Storage and File Structure

   • Unit 1: Computer Data Storage and Level · 5 hours

     Describe computer data storage.. Classify the levels of storage.. Itemise the fundamental components of a basic computer..

9. Week 9Module 4: Computer Data Storage and File Structure

   • Unit 2: Features of Storage Technologies · 5 hours

     Outline the core characteristics of storage technologies.. Differentiate between the volatile and non-volatile memory.. Explain the mechanism of the Read/Write storage..

10. Week 10Module 4: Computer Data Storage and File Structure

    • Unit 3: Common Storage Technologies · 5 hours

      Explain the storage mechanism of semi conductor memory.. Describe the storage mechanism of the magnetic storage, optical disc and the magneto-optical disc storage.. Differentiate between the optical disc and the magneto-optical disc storage..

11. Week 11Module 4: Computer Data Storage and File Structure

    • Unit 4: File Organisation · 5 hours

      Explain the concept of file organisation.. Identify the components of file organisation.. State the key considerations in specifying a system of file organisation..

12. Week 12Module 5: Introduction to XML and Web Services

    • Unit 1: Fundamentals of XML · 5 hours

      Give a brief description of an XML.. Describe the common concepts of XML.. Identify the components of a Structured Document..

    • Unit 2: Significance of XML · 5 hours

      Give a concise description of the import of XML.. Identify the development goals of extensible markup languages (XML).. Know how you would view an XML document, assuming you do not have an XML browser..

13. Week 13Module 5: Introduction to XML and Web Services

    • Unit 3: XML Document · 5 hours

      Describe a simple XML document.. Outline the main ideas of a model XML document.. Explain the term ‗character references'..

    • Unit 4: Document Type Declaration · 5 hours

      Explain the notion of document declaration.. Identify the components of meta-information.. Describe the four main types of declarations in XML..

    • Unit 5: Introduction to Web Services · 5 hours

      Describe how Web Services are published.. Discuss the procedure involved in accessing information from Web Services.. Specify the common advantages and disadvantages of Web Services..