IT 414

Introduction to Databases (3 credits)

Text:  Fundamentals of Database Systems, 7th edition by R. Elmasri and S. Navathe, Pearson, 2016.

Course Information: The objective of this course is to present key concepts related to database design and implementation. Topics to be discussed include: database architecture, relational data model, SQL, database design life cycle, conceptual data modeling, relational database normalization, query processing, transaction processing, database security, and database administration. This is a project-driven course.

Prerequisite: IT 330

Required/Elective: Elective

Course Outcomes:

Students should be capable of:

  1. Understanding the database design life cycle and using a conceptual modeling tool to model enterprise data requirements and producing a conceptual data model
  2. Demonstrating an understanding of database modeling and, in particular, the relational data model concepts
  3. Using a language such as SQL to retrieve, manipulate, and store data in a database
  4. Mapping a logical database model into a physical model via a project
  5. Demonstrating an understanding of knowledge management

Student Outcomes: 

J. An ability to use and apply current technical concepts and practices in the core information technologies

K. An ability to identify and analyze user needs and take them into account in the selection, creation, evaluation and administration of computer-based systems

L. An ability to effectively integrate IT-based solutions into the user environment

Course Topics:

  1. Key terms such as information, data, database, data management systems, metadata, and data mining
  2. Database systems
  3. Database architecture
  4. Conceptual modeling via Entity-Relationship diagrams
  5. Data definition and manipulation languages (e.g. SQL, XQuery, XPath)
  6. Data organization (including relational, object-oriented and XML databases)
  7. Normal forms and related concepts (entity integrity, referential integrity, integrity constraints)
  8. Conceptual, logical, and physical models
  9. Database design lifecycle
  10. Database security
  11. Relational data model
  12. Relational database normalization
  13. Transaction processing
  14. Database recovery
  15. Database administration
  16. Distributed databases

One of 34 U.S. public institutions in the prestigious Association of American Universities
44 nationally ranked graduate programs.
—U.S. News & World Report
Top 50 nationwide for size of library collection.
5th nationwide for service to veterans —"Best for Vets: Colleges," Military Times
KU Today