• Skip to Content
  • Skip to Main Navigation
  • Skip to Search

Kelley School of Business Indiana University
  • Programs
    • Undergraduate
    • Full-Time MBA
    • Kelley Direct Online MBA
    • Online Master’s Degrees
    • +Kelley
    • 3/2 MBA
    • MS in Accounting with Data and Analytics
    • MS in Finance
    • MS in Healthcare Management
    • MS in Information Systems
    • PhD
    • Executive Degree Programs
    • Executive Education
    • Indianapolis Programs
    • International Programs
  • Faculty & Research
    • Research & Publications
    • Faculty Directory
    • Departments & Majors
    • Centers & Institutes
    • Courses
  • Recruiters & Corporate Relations
    • Graduate Career Services
    • Undergraduate Career Services
    • Indianapolis Career Services
    • Alumni Career Resources
    • Corporate & Foundation Relations
    • Indianapolis Corporate & Foundation Relations
  • Diversity
    • Undergraduate Initiatives
    • Graduate Initiatives
    • Indianapolis Initiatives
    • Alumni Legacies
  • Alumni
    • Who We Are
    • Get Involved
    • Career & Professional Development
    • Awards
    • Events
    • Contact Us
  • About Us
    • Dean's Welcome
    • Administration
    • Kelley Women
    • School Profile
    • History
    • Visit Bloomington
    • Visit Indianapolis
    • Contact
    • Directory
    • Social Media Directory
    • Rankings
  • More
    • Centers & Institutes
    • Directory
    • News & Events
    • Give
    • Kelley Store
  1. Home
  2. Faculty & Research
  3. Courses

BUS-S307 Database Design & Management

  • 16 weeks
  • 3 credits
  • Prerequisite(s): BUS-K201 or BUS-K204 with a C or higher

This course focuses on the entire lifecycle of data management—eliciting data requirements, conceptual and logical design, and database implementation and use—along with the software that is used to manage the database, or, a database management system (DBMS). Students will develop an understanding of database concepts and learn how to use database systems to solve business problems. The topics include conceptual design (e.g., ER model), logical design (relational model, normalization, integrity constraints, keys, functional dependency), physical design (denormalization, data partitioning), key elements of SQL including Data Definition Language (DDL), Data Manipulation Language (DML) and Data Control Language (DCL), querying using SQL (functions, views, different types of joins such as inner-join, outer join, and subquery). Using hands-on tools (e.g., Visio, Oracle, MongoDB), students learn how to operationalize and apply key concepts of database design and write SQL/NoSQL queries to develop dashboards that dove-tail with business needs.

Social media

  • Facebook for the Kelley School of Business Full-Time MBA Program
  • Twitter for the Kelley School of Business Full-Time MBA Program
  • Linkedin for the Kelley School of Business Full-Time MBA Program
  • Blog for the Kelley School of Business Full-Time MBA Program
  • Instagram for the Kelley School of Business Full-Time MBA Program
  • Youtube for the Kelley School of Business Full-Time MBA Program
  • Accessibility
  • Privacy Notice
  • Copyright © 2023 The Trustees of Indiana University