Loading......

Password

Download DT3019PPT zip file to your own computer for self-study and lecture purposes

Class Syllabus

Course Title and number: DT 3019 Database
Instructor: Dr. Dejang Liu, Professor
Prerequisite(s): Any college-level programming class or consent of the instructor
Start week of: Sep. 1, 2025
End week of: Nov. 17, 2025
Credit hours: 5 credit hours

Course Materials

Textbook:

Database Systems Concepts, by Abraham Silberschatz, Henry Korth, and S. Sudarshan, 7th Ed., ISBN10: 0078022150, ISBN13: 9780078022159, https://www.mheducation.com/

Software (optional, not required):

• Microsoft Access
• Microsoft SQL Server
• MySQL
• SQLite (www.sqlite.org)
• Oracle SQL+/iSQL (www.oracle.com)
• Browser: Mozilla Firefox or Google Chrome
• Microsoft Visio, Word, PowerPoint or similar tools to draw

Learning outcomes/competences

Students:

• acquire basic knowledge about the architecture, functioning, and use of database systems, and know the principles of the organization of a database system
• acquire knowledge about modern (object-oriented) and classic data modelling, including the meaning of normalization rules
• are able to perform a complete relational database design, starting from a requirements specification, and are proficient in standard SQL to perform simple and complex queries, as well as change operations.
• gain the ability to evaluate and select database technologies
• can plan and implement database projects and develop a modern database application

Learning contents:

• Introduction to database concepts and database technologies (data modelling, normalization theory, database language SQL)
• Basics of database systems (database design, database definitions, database queries)
• Data Manipulation Language (DML)
• Data Definition Language (DDL)
• Data Control Language (DCL)
• Efficiency of SQL queries, index structure
• Authorization concepts

Final Grade Scales

Final Grade Assignment total possible points = 1000

• A (90%) 900-1000 points
• B (80%) 800-899 points
• C (70%) 700-799 points
• D (60%) 600-699 points
• F 0-599 points

  Grade Allocations

• Assignments 850 points
• Final database design presentation 100 points
• Class participation 50 points

Only on-time assignments are eligible for revision. Revise from the graded file rather than from a new one, so comments left in the graded file can be seen, or no credit for revision.

Database design presentation requirements and guidelines

1. Form a group of up to 3 members
2. Obtain instructor approval for your E-R (Entity-Relationship) diagram (after chapter 7 taught) before proceeding
3. At least one pair of tables with a one-to-many relationship
4. Create a database by using any database management software of your choice
5. Generate and insert sample records into your tables
6. Maximum 10-minute presentation covering the following:
   • E-R diagram
   • Methods used to create tables
   • Methods used to insert records

Lecture tentative schedule

Website for a Self-taught SQL application

Web site for SQL tutorials