Unit I Course Project Textbook Hands-On Database By Steve Co

Unit I Course Projecttext Book Hands On Database By Steve Congerfor T

Choose one of the first three scenarios from the end of Chapter 1 (on pages 17-18): “Wild Wood Apartments,” “Vince’s Vinyl,” or “Grandfield College.” You will work on the scenario you choose throughout the course. Do NOT choose the scenario titled “Westlake Research Hospital” as it will serve as an example throughout the course, starting in Unit II. Review the scenario on pages 17 or 18, and follow the instructions below to develop your project.

Review the “Deliverables” section below, as well as the “Suggestions for Scenarios” on page 19 of your textbook. Additionally, examine “The Statement of Work” on pages 13 to 15 to model your own statement. Once all deliverables are completed, compress the files into a single .zip file for submission. Contact your instructor if any questions arise. The submission of these items will begin in Unit II.

Paper For Above instruction

The chosen scenario from the textbook serves as the foundation for developing a comprehensive database project in this course. The assignment involves several critical steps: identifying major topics, drafting a statement of work, and maintaining an electronic documentation notebook to document progress. This structured approach ensures clarity in scope, objectives, and timelines, facilitating systematic development and management of the database project.

First, selecting one of the three specified scenarios—“Wild Wood Apartments,” “Vince’s Vinyl,” or “Grandfield College”—provides contextual focus for the project. Each scenario offers unique data management challenges and opportunities that align with real-world applications. For instance, “Wild Wood Apartments” might involve managing tenant information, leasing details, and maintenance schedules. “Vince’s Vinyl” could focus on inventory management, sales, and customer data for a music store. “Grandfield College” would entail student records, course management, and faculty data. Choosing a scenario allows tailoring the database design process to specific needs, creating relevant data models, relationships, and queries.

The second component involves preparing a “Statement of Work” (SOW), which acts as a strategic planning document. This statement should include a brief history of the project’s context, clearly defining the scope of work, project objectives, and a preliminary timeline. Drawing on the textbook’s example on pages 13-15, the SOW establishes expectations and guides the project’s development process. It ensures all stakeholders are aligned and provides benchmarks for progress evaluation. An effective SOW details the goals, constraints, deliverables, and resources required, setting a foundation for subsequent design and implementation phases.

The third element emphasizes documentation, wherein an electronic notebook is maintained throughout the project. This notebook captures all notes, updates, decisions, and revisions made during the development process. Starting early with recording the statement of work and initial ideas ensures a comprehensive trail of the project’s evolution. Proper documentation facilitates communication, provides reference points, and enhances project management. The electronic notebook will be submitted starting in Unit II and should be continuously updated as work progresses.

Furthermore, understanding the deliverables is essential. The major topics list should outline the core components of the database, such as tables, relationships, and data requirements tailored to the selected scenario. The draft statement of work should summarize the historical context, scope, objectives, and timelines for the project. This structured approach enables systematic development, aligning with best practices in database design and project management. Incorporating feedback, adhering to deadlines, and maintaining comprehensive documentation will contribute to successful project delivery and a solid foundation for further course activities.

References

• Conger, S. (2016). Hands-On Database. Course Technology.
• Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems (7th ed.). Pearson.
• Rob, P., & Coronel, C. (2009). Database Systems: Design, Implementation, & Management (8th ed.). Cengage Learning.
• Connolly, T., & Begg, C. (2015). Database Systems (6th ed.). Pearson.