UUY-DTS 1122 units100 LevelFirst Semester

Introduction to Database Technology

B.Sc. Data Science, University of Uyo

UUY-DTS 112 (Introduction to Database Technology) is a 2-unit, 100 Level course taught in the First Semester at the University of Uyo, Akwa Ibom State, Nigeria.

How data is stored, structured and retrieved at scale. Relational modelling, normalisation, and SQL — the single most reusable practical skill in the degree, and the one most often tested in data-science job interviews.

On Areté, UUY-DTS 112 comes with

  • 2 recommended textbooks
  • an AI tutor that has read this course’s outline and notes
Sign in to study UUY-DTS 112

Free for University of Uyo students — sign in with your email, no password.

Course outline

  1. 01File systems vs database systems; why databases exist
  2. 02Database system architecture: the three-schema architecture and data independence
  3. 03Data models: hierarchical, network, relational, object and document models
  4. 04Entity-relationship modelling: entities, attributes, relationships, cardinality, ER diagrams
  5. 05The relational model: relations, tuples, keys (primary, candidate, foreign), integrity constraints
  6. 06Normalisation: functional dependency, 1NF, 2NF, 3NF and BCNF
  7. 07SQL data definition: CREATE, ALTER, DROP, constraints
  8. 08SQL data manipulation: SELECT, WHERE, ORDER BY, GROUP BY, HAVING, JOIN, subqueries, aggregate functions
  9. 09Transactions and the ACID properties; introduction to NoSQL alternatives

Recommended textbooks

  • Database System Concepts — Silberschatz, Korth & Sudarshan

    7th ed. — the standard university text

  • Learning SQL — Alan Beaulieu

    3rd ed. — the fastest route to practical SQL fluency

How to pass UUY-DTS 112

  • Install PostgreSQL or SQLite locally in week one and write real queries — SQL cannot be learnt by reading
  • Normalisation questions are guaranteed in the exam: practise taking an unnormalised table to 3NF and stating the functional dependency that forced each step
  • Master JOINs properly (INNER, LEFT, RIGHT, FULL) — they are the number one SQL interview topic and reappear in DTS 314
  • SQLBolt and pgexercises.com are free, interactive, and better practice than any past question paper

UUY-DTS 112 — questions and answers

What is UUY-DTS 112 at the University of Uyo?
UUY-DTS 112 (Introduction to Database Technology) is a 2-unit, 100 Level course taught in the First Semester at the University of Uyo, Akwa Ibom State, Nigeria. How data is stored, structured and retrieved at scale. Relational modelling, normalisation, and SQL — the single most reusable practical skill in the degree, and the one most often tested in data-science job interviews.
What topics are covered in UUY-DTS 112?
The UUY-DTS 112 outline covers 9 topics: File systems vs database systems; why databases exist; Database system architecture: the three-schema architecture and data independence; Data models: hierarchical, network, relational, object and document models; Entity-relationship modelling: entities, attributes, relationships, cardinality, ER diagrams; The relational model: relations, tuples, keys (primary, candidate, foreign), integrity constraints; Normalisation: functional dependency, 1NF, 2NF, 3NF and BCNF; SQL data definition: CREATE, ALTER, DROP, constraints; SQL data manipulation: SELECT, WHERE, ORDER BY, GROUP BY, HAVING, JOIN, subqueries, aggregate functions; Transactions and the ACID properties; introduction to NoSQL alternatives.
What textbooks are recommended for UUY-DTS 112?
Recommended reading for UUY-DTS 112: Database System Concepts by Silberschatz, Korth & Sudarshan; Learning SQL by Alan Beaulieu.
How do I pass UUY-DTS 112?
Install PostgreSQL or SQLite locally in week one and write real queries — SQL cannot be learnt by reading Normalisation questions are guaranteed in the exam: practise taking an unnormalised table to 3NF and stating the functional dependency that forced each step Master JOINs properly (INNER, LEFT, RIGHT, FULL) — they are the number one SQL interview topic and reappear in DTS 314 SQLBolt and pgexercises.com are free, interactive, and better practice than any past question paper
Where can I find UUY-DTS 112 lecture notes and past questions?
Areté (https://www.aretecyb.tech/courses/uuy-dts-112) carries 2 recommended textbooks for UUY-DTS 112, plus an AI tutor that has read the outline. It is free for University of Uyo students — sign in with your email, no password.

Other 100 Level courses

Lecture notes, practice questions and the AI tutor for UUY-DTS 112 are available once you sign in.

Sign in to Areté