Walden - Current Students - NTU - Course Desc

Inside.Waldenu.Edu>Degree Program Resources>NTU Course Schedule>Current Students - NTU - Course Desc - NCSC- 6401
Inside.Waldenu.Edu Inside.Waldenu.Edu Academic Calendar Bookstore Career Services- New! Catalog Commencement Degree Program Resources Disability Services eMall at WaldenU Faculty Governance Financial Aid Financial Services Forms KAMs Library Office of the Chief Academic Officer Registrar Research Center Residencies Student Organizations Student Support & Customer Service Writing Center Veteran's/Military Benefits	NCSC-6401 Database Management Systems (CS 750) Contributing Scholar - Shaski Shekhar, University of Minnesota 3 Semester Credit Hours Course Description This course helps you learn about relational database management systems, which are a core technology for the information age. We discuss database concepts underlying the important application domains of informed decision making and work-flow automation. Prerequisites Exposure to basic data structures including search trees, hashing, and syntax trees. This material is covered in a course like NCSC 3011 Exposure to basic operating systems concepts such as files, processes and network file systems. This material is covered in a course like NCSC 3101 Some experience with use of information systems such as the World Wide Web and search engines General prerequisite: Students must have the knowledge resulting from completing all coursework in the curriculum for a BS degree in Computer Science from a regionally-accredited institution in the United States or the equivalent from a foreign institution; performance level in this coursework should be equivalent to a cumulative undergraduate GPA of 2.9 or better on 4.0 scale Course Objectives Understand the relational data model Use SQL to define, populate, and query database tables Design a database for an information system, given business requirements Appreciate the impact of new technologies (e.g. objects, Internet ) on databases Course Topics The following topics will be covered in the order given. Introduction to database management The relational data model Relational algebra Advanced relational algebra Query formulation with SQL Introduction to database development Understanding entity relationship diagrams Developing data models for business databases Normalization Physical database design Advanced query formulation with SQL Transaction management Data warehouse technology and management Client-server processing and distributed databases Object database management systems Technical Requirements It is recommended that you have access to a SQL query able database for this course. In addition, you will be required to have Windows Media Player to view the lectures. For the standard technical requirements, please go to the link below: http://www.waldenu.edu/c/Files/DocsGeneral/Getting_Started_Guide.pdf Textbook Required: Database Design, Application Development and Administration, M. Mannino, McGraw Hill, 3rd edition, ISBN: 0-07-294220-7. (McGraw-Hill has indicated this book is available in an electronic digital format for $73.73 for students). Disclaimer: The course syllalbus may differ slightly from this. Course descriptions will be provided in your online course. Textbook information is provided only to give more information about the course. Do Not use this information to purchase a textbook. Up-to-date information will be provided when you register.

| |