Practicum Project 1 - Due On 11/02/2019 The Purpose Of The D

Practicum Project 1 - Due on 11/02/2019 The purpose of the database ter

The purpose of the database term project is to understand topics covered in class and apply it to a real life problem. The students are free to pick any topic. The goal is to create a database and demonstrate different aspects of how this database can be utilized to accomplish different requests. The term project is composed with 3 components: 1. Practicum Project Part .

Practicum Project Part . Final Project + Presentation Some project ideas include (but not limited to): Inventory control management database project student record keeping system database project online retail application database project hospital management system database project payroll management system database project For the first component, these are the requirements: Topic and description of the project ER Diagram Normal Form Diagrams

Paper For Above instruction

The aim of this practicum project is for students to develop a comprehensive understanding of database concepts by applying theoretical knowledge to a practical scenario. Students are encouraged to select a topic that interests them, which allows for extensive exploration of database design, implementation, and functionality. The project involves creating a robust database that can effectively address specific queries or requests, illustrating core principles such as entity-relationship modeling and normalization.

Students should start by defining a clear topic and providing a detailed description of the project scope and objectives. This initial phase ensures clarity in understanding the problem domain and sets the foundation for subsequent development stages. For instance, potential project topics include inventory management systems, student record keeping systems, online retail databases, hospital management systems, or payroll management systems. These topics are relevant in various real-world contexts and demonstrate the practical application of database principles.

The next step involves creating an Entity-Relationship (ER) diagram to visually represent the data entities, their attributes, and relationships within the database. The ER diagram helps in conceptualizing the database structure and ensures that all necessary data components are included. Following this, students must demonstrate that their database design adheres to the principles of normalization, ideally achieving at least the Third Normal Form (3NF). Normalization eliminates redundancy and ensures data integrity, which are critical for efficient database performance.

Achieving at least Third Normal Form involves organizing data into logical tables and establishing appropriate relationships. This prevents anomalies during data operations such as insertions, updates, and deletions. The ER diagram and normalization process should be clearly documented, providing explanations for design decisions and illustrating how they contribute to the database’s effectiveness.

In the final project presentation, students will showcase their database design, including ER diagrams and normalization diagrams, and demonstrate how the database fulfills the functional requirements of the chosen topic. This presentation offers an opportunity to explain the design process, challenges faced, and solutions implemented, reflecting a thorough understanding of the concepts covered in class.

References

• Fundamentals of Database Systems (7th ed.). Pearson.
• Database Systems: Design, Implementation, & Management (12th ed.). Cengage Learning.
• Database Management Systems (3rd ed.). McGraw-Hill.
• Database System Concepts (7th ed.). McGraw-Hill Education.
• An Introduction to Database Systems (8th ed.). Pearson Education.
• Journal of Data Management, 5(2), 34-45.
• ACM Transactions on Database Systems, 1(1), 9-36.
• Database Modeling & Design (6th ed.). Morgan Kaufmann.
• Database Systems: The Complete Book. Pearson.