What This Document Is
This is a practical lab exercise designed for an introductory Information Systems course (ITMG 100) at the University of San Diego. It focuses on applying database management skills using a specific database environment – likely Microsoft Access, though this isn’t explicitly stated. The exercise centers around a real-world scenario involving the management of movie sales data for a theater chain. Students will be tasked with manipulating and querying a pre-existing database to extract meaningful insights. It builds upon previously learned concepts of database design and implementation.
Why This Document Matters
This lab is crucial for students seeking to solidify their understanding of relational database concepts. It’s particularly beneficial for those who learn best by doing, as it requires hands-on application of theoretical knowledge. Students preparing for roles involving data analysis, business intelligence, or database administration will find the skills practiced here directly applicable. Completing this exercise successfully demonstrates proficiency in database operations, a foundational skill in the field of Information Systems. It’s best used *after* foundational lectures on database design, relationships, and query languages.
Common Limitations or Challenges
This exercise does not provide a comprehensive introduction to database theory. It assumes a basic understanding of database concepts and terminology. It also doesn’t cover advanced database administration tasks like security or performance tuning. The exercise focuses specifically on a movie sales database; the principles learned may need to be adapted for different data scenarios. Furthermore, while guidance is available, the exercise requires independent problem-solving and debugging skills. It does *not* provide step-by-step instructions for every task.
What This Document Provides
* A database schema to work with, centered around movie sales and employee information.
* Data input scenarios simulating a real-world business operation.
* A series of query challenges designed to test your ability to retrieve specific information from the database.
* Opportunities to practice creating database relationships.
* A framework for calculating derived data within a database environment.
* Instructions for exporting query results for further analysis and visualization.
