ISYS 464 Syllabus 9293 (1).pdf - Syllabus for ISYS 464 MANAGING ENTERPRISE DATA Fall 2018 Class Number 9293 Professor Guillaume Faddoul Classroom

ISYS 464 Syllabus 9293 (1).pdf - Syllabus for ISYS 464...

This preview shows page 1 - 3 out of 6 pages.

Syllabus for ISYS 464 MANAGING ENTERPRISE DATA Fall 2018 Class Number: 9293 Professor: Guillaume Faddoul Classroom: Business Building 126 Day & Time: Thursday 4:00 pm 6:45 pm Final Exam: Thursday, December 20, 4:00 pm 6:45 pm Office Location: BUS 305 Office Phone Number: TBD Office Hours: Tuesday, Thursday 1:30 pm 3:30 pm E-mail: [email protected] Web: Course Description ISYS 464 is an introduction course to the design, use, and implementation of databases in organizations, and to the functions and use of database management systems (DBMS). The topics covered include data models and physical representation of databases; the conceptual and logical design of databases; and database definition, control, and manipulation using SQL. Prerequisites ISYS 363 and ISYS 350 both with grade of C- or higher. Course Objectives and SLOs Students should be able to: 1. Explain the purpose of the database concept and identify its strength and risks. 2. Represent a database following the Entity-Relationship model and explain the components of this design. 3. Discuss concept of logical database and design relational databases using normalization. 4. Use SQL commands to define database structures and perform operations in databases. 5. Discuss basic concept of data warehousing and overall data management and analysis. Required Textbook Hoffer/Ramesh/Topi, “Modern Database Management”, 12th Edition, Prentice Hall Publishing, 2016. ISBN-13: 978-0133544619 A digital version is also available at bookstore. Attendance and Participation Students are expected to attend all class sessions and to complete their work on time (see weekly schedule below). Any student missing more than two consecutive class meeting must call or e-mail to inform the instructor. Missing more than 2 class meetings could seriously jeopardize a student’s grade and could, without
Image of page 1