Skip Navigation
 
 

INFO620 - Enterprise Database Systems

Course Details

Course Code: INFO620 Course ID: 4097 Credit Hours: 3 Level: Graduate

This course examines the principles, practices, and methodologies of enterprise database systems from conceptual design to implementation; this includes architectures, models, design, management, implementation, and security. Included is a total life-cycle database design and implementation project that entails conceptual design, data modeling, normalization, optimization, and implementation. This course appraises object-relational and relational databases, examines Entity-Relationship (ER), Extended Entity-Relationship (EER), and Unified Modeling Language (UML) data models, and investigates relational procedures, dependencies, keys, relationships, cardinality, and referential integrity. It also evaluates query processing, performance tuning, transaction processing, concurrency, data integrity, database recovery, data security, data warehousing, data mining, and emerging technologies. Prior knowledge in a procedural database language such as PL/SQL or T/SQL using Oracle or MSSQL respectively is highly recommended.





Course Schedule

Registration Dates Course Dates Session Weeks
01/28/19 - 06/28/19 07/01/19 - 08/25/19 Summer 2019 Session B 8 Week session
04/29/19 - 10/04/19 10/07/19 - 12/01/19 Fall 2019 Session B 8 Week session

Current Syllabi

  1. Analyze the architecture, structure, purpose, characteristics, design, administration, and efficiency of various database systems
  2. Develop Entity-Relationship (ER), enhanced entity-relationship (EER) and UML models
  3. Examine relational model theory, concepts, constraints, schemas, update operations anomalies, constraints violations, relational algebra
  4. Evaluate functional dependencies and normalization in relational model theory
  5. Examine use case, sequence, collaboration, state charts, transition diagrams, and activity diagrams
  6. Examine object database and object-oriented database concepts
  7. Assess and expound on database security and authorization
  8. Investigate data warehousing and OLAP (data modeling, cubes, functionality, and technology issues)
  9. Appraise focused applications such as mobile, multimedia, geographic information systems, and biological genome database systems

This course is based on both practical and theoretical aspects of advanced database management concepts, rules, techniques, applications, and deductions. It requires hands-on practices on databases techniques based on theories introduced in the class, the derivation of practicality in today’s capabilities on techniques presented in the class, as well as deducing the means by which they can be applied to today’s work environments with currently available technologies. The fundamental theory is introduced – how we can apply them – is left to individual scenarios. The goal is to organize, synthesize, and demonstrate your comprehension of core concepts investigated during this course by applying a combination of the terms, concepts, and details you have learned in a systematic way. As important as "the details" that you analyze and arrange in your projects and exercises, however, are the conclusions you draw from those details, and your predictions, responses to, and ultimate interpretation of those details.

Research Paper Topic: You must submit a Research Paper Topic in Week 2 of the course, an Annotated Bibliography in week 3, an Outline in Week 5, and the Project Paper in Week 7. In week 8 you will post your paper for peer review onto the Forum area.

NameGrade %
Forum Discussion 32.00 %
Introduction Forum 3.56 %
Week 1 Forum 3.56 %
Week 2 Forum 3.56 %
Week 3 Forum 3.56 %
Week 4 Forum 3.56 %
Week 5 Forum 3.56 %
Week 6 Forum 3.56 %
Week 7 Forum 3.56 %
Week 8 Forum 3.56 %
Assignment Exercise 30.00 %
Week 1 Assignment 5.00 %
Week 2 Assignment 5.00 %
Week 3 Assignment 5.00 %
Week 4 Assignment 5.00 %
Week 5 Assignment 5.00 %
Week 8 Assignment 5.00 %
Research Paper Topic 2.00 %
Week 2 Project Topic Selection 2.00 %
Research Paper Outline 5.00 %
Week 5 Research Paper Outline 5.00 %
Research Paper Final with Acceptable Originality Report 15.00 %
Week 7 Research Paper Final 15.00 %
Research Paper Bibliography 2.00 %
Week 4 Research Paper Bibliography 2.00 %
Project Peer Review (Forum) 4.00 %
Project Peer Review 4.00 %
Database Lab 10.00 %
Database Lab 10.00 %

Software Requirements

  1. Microsoft Office (MS Word, MS Excel, MS PowerPoint, MS Access)
  2. Adobe Acrobat Reader (Click here for free download)

Selected Bibliography

  1. The authors’ companion site: http://www.pearsonhighered.com/elmasri
  2. ACM digital library: http://portal.acm.org/dl.cfm
  3. Google Scholar : http://scholar.google.com/
  4. IEEE digital library: http://www.computer.org/portal/web/csdl/home
Book Title:Fundamentals of Database Systems, 7th ed.
ISBN:9780133970777
Publication Info:Pearson
Author:Elmasri, R. and Navathe, S.
Unit Cost:$153.79

Previous Syllabi

Not current for future courses.