COP-4710-U04A -- Database Management -- Fall-A, 2020

Professor: Nagarajan Prabakar (naa-ga-raa-jan pra-baa-kar)

Phone: 305-348-2033 E-mail: prabakar@cis.fiu.edu Office: CASE-382/Remote

Office Hours:

Tue: 4:00-4:45pm, 6:30-7:30pm
Thu: 4:00-6:00pm
or by appointment

Course Description:

Covers logical aspects of databases including Relational, Entity-Relationship, and Object-Oriented data models, database design, SQL, relational algebra, tuple calculus, domain calculus, and physical database organization.

Prerequisite: COP3337    and   Corequisite: COP3530

Detailed Syllabus (pdf file)

Course Outcomes:

Be exposed to information systems

Be familiar with database system and database architecture

Master the design conceptual schemas

Master normalization theory and the mapping of a conceptual schema to a relational schema

Master the expression of queries in SQL, relational algebra, and relational calculus

Be familiar with physical database design

Be familiar with writing application programs that use SQL

Course Content:

Database system concepts and architecture

Conceptual E-R model, Relational model, Relational Algebra, Relational Calculus, and QBE

Structured Query Language

Functional dependencies and normalization for relational databases, Relational database design

Physical database design

Embedded queries

Textbook:

"Fundamentals of Database Systems" (7th Edition) by Elmasri and Navathe [ISBN: 0-13-397077-9] Pearson

Grading:

20% quizzes

25% assignments

25% midterm exam (Friday, Sep 18th 5:00-6:30pm)

25% final exam (Friday, Oct 9th 5:00-6:30pm)

5% class (zoom/poll) participation

I will use the following relative grading scheme.

Other Issues:

I expect you to maintain a high level of academic integrity in this course. Please read FIU's Code of Academic Integrity. You are allowed to consult other books in solving assignment problems, or to discuss the problems with other students, but you must write your queries/programs on your own.

I will grant incompletes only in extreme circumstances, such as medical emergencies with proper documentation.

I expect you to attend class regularly and promptly, and to participate in discussions. Feel free to ask questions -- if something is unclear to you, it is probably unclear to others as well.

System: John C. Comfort Lab (ECS 241)

PC workstations and SQL servers

For additional course information, please visit FIU LMS Support

Discussion Forums

Keep in mind that your discussion forum postings will likely be seen by other members of the course. Care should be taken when determining what to post.

Important Information

Before starting this course, please read the following pages: