 | Select the Course Number to get further detail on the course. Select the desired Schedule Type to find available classes for the course. The Schedule Type links will be available only when the schedule of classes is available for the selected term. |
| MGMT 54400 - Database Management Systems |
|
Credit Hours: 3.00. Covers the theory and practice of database design and usage. Students will learn the importance of data modeling concepts and how to use these effectively and how to plan and design a database, including issues such as data security and control. The following course is recommended: MGMT 29000 Programming for Business Applications or CS 15900 or CS 17700 or CNIT 17500, all with a C- or higher. Typically offered Fall Spring.
3.000 Credit hours Syllabus Available Levels: Undergraduate, Graduate, Professional Schedule Types: Lecture Offered By: School of Management Department: School of Mgmt Adm & Instr Course Attributes: Upper Division May be offered at any of the following campuses: West Lafayette Continuing Ed Northwest- Hammond West Lafayette Learning Outcomes: 1. Understand why database management is important and what it entails. 2. Analyze the database requirements of a business scenario and represent these requirements by means of entity-relationship (ER) diagrams. 3. Translate an ER diagram into normalized relations for a relational DBMS. 4. Design and implement an Oracle database. 5. Write simple and relatively complex data retrieval and maintenance commands in the SQL language. 6. Use Microsoft Access as a front end to a server database in Oracle. 7. Appreciate major data administration tasks, including security control, backup and recovery, and concurrency control. 8. Be familiar with data warehousing and its basic conceptual design. |
 |