Login Create Account

Back to Course Catalog

CIT427Sciences3 Unitsintermediate

Database System and Management

This course provides an introduction to database systems and management, covering the design and programming aspects. Students will learn about the ER approach to data modeling, the relational model of DBMSs, and query languages like SQL. The course also touches upon relational algebra, query processing, data storage, file structure, XML documents, and Web Services. It aims to equip students with the skills to handle database systems effectively.

Generate AI Study Notes

Transform this course into personalized study materials with AI

273h

Study Time

13

Weeks

21h

Per Week

basic

Math Level

Course Keywords

Database Management SystemsSQLData ModelingXMLWeb Services

Course Overview

Everything you need to know about this course

Course Difficulty

Intermediate Level

Builds on foundational knowledge

65%

intermediate

➕

Math Level

Basic Math

📖

Learning Type

Theoretical Focus

Course Topics

Key areas covered in this course

1

Database Management Systems

2

Data Models

3

Entity-Relationship Model

4

SQL

5

Data Storage

6

File Structure

7

XML

8

Web Services

Total Topics8 topics

Ready to Start

No specific requirements needed

This course is designed to be accessible to all students. You can start immediately without any prior knowledge or specific preparation.

Assessment Methods

How your progress will be evaluated (3 methods)

Assignments

Comprehensive evaluation of course material understanding

Written Assessment

Tutor-Marked Assignments

Comprehensive evaluation of course material understanding

Written Assessment

Final Examination

Comprehensive evaluation of course material understanding

Written Assessment

Career Opportunities

Explore the career paths this course opens up for you

Database Administrator

Apply your skills in this growing field

Data Analyst

Apply your skills in this growing field

Web Developer

Apply your skills in this growing field

Software Engineer

Apply your skills in this growing field

IT Consultant

Apply your skills in this growing field

Industry Applications

Real-world sectors where you can apply your knowledge

FinanceHealthcareE-commerceEducationGovernment

Study Schedule Beta

A structured 13-week journey through the course content

Week

1

Module 1: Introduction to Database Management Systems

5h

Unit 1: Basic Concepts of Database Management Systems

5 study hours

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

Week

2

Module 1: Introduction to Database Management Systems

5h

Unit 2: Data Models

5 study hours

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

Week

3

Module 1: Introduction to Database Management Systems

10h

Unit 3: Instances and Schemes

5 study hours

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

Unit 4: Overall System Structure

5 study 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.

Week

4

Module 2: The Entity-Relationship Data Model

10h

Unit 1: Entities and Entity Sets

5 study hours

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

Unit 2: Relationships and Relationship Sets

5 study hours

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

Week

5

Module 2: The Entity-Relationship Data Model

10h

Unit 3: Structure of Relational Database

5 study 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 study hours

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

Week

6

Module 3: SQL and Integrity Constraints

10h

Unit 1: Structured Query Language (SQL) Fundamentals

5 study 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 study 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.

Week

7

Module 3: SQL and Integrity Constraints

10h

Unit 3: Database Modification

5 study 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 study 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.

Week

8

Module 4: Computer Data Storage and File Structure

5h

Unit 1: Computer Data Storage and Level

5 study hours

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

Week

9

Module 4: Computer Data Storage and File Structure

5h

Unit 2: Features of Storage Technologies

5 study hours

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

Week

10

Module 4: Computer Data Storage and File Structure

5h

Unit 3: Common Storage Technologies

5 study 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.

Week

11

Module 4: Computer Data Storage and File Structure

5h

Unit 4: File Organisation

5 study hours

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

Week

12

Module 5: Introduction to XML and Web Services

10h

Unit 1: Fundamentals of XML

5 study 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 study 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.

Week

13

Module 5: Introduction to XML and Web Services

15h

Unit 3: XML Document

5 study 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 study 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 study 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.

This study schedule is in beta and may not be accurate. Please use it as a guide and consult the course outline for the most accurate information.

Course PDF Material

Read the complete course material as provided by NOUN.

Access PDF Material

Study Tips & Exam Preparation

Expert tips to help you succeed in this course

1

Review all tutor-marked assignments and their solutions to identify areas of weakness.

2

Create flashcards for key SQL commands and data modeling concepts.

3

Practice writing SQL queries for different scenarios, focusing on joins and subqueries.

4

Create diagrams illustrating the different data storage levels and their characteristics.

5

Summarize the main advantages and disadvantages of different file organization techniques.

6

Review XML syntax and document type declarations, focusing on elements and attributes.

7

Practice with sample XML documents and Web Service descriptions.

8

Allocate specific study hours for each module based on its complexity and your familiarity with the topics.

9

Form a study group with classmates to discuss challenging concepts and share insights.

10

Take practice exams under timed conditions to improve time management skills.

Related Courses

Other courses in Sciences that complement your learning

Photochemistry And Pericyclic Reactions

Geographical Information Systems

Visual Programming And Applications

View All Sciences Courses