College of Technological Innovation CIT 365 Database Systems Term Project Design and Construct a database system for a business case for at least three constraint tables. The tables should contain a reasonable number of constraint tuples (rows), not too few and not too many. Each team must select a unique project and write a description of one page that contain the problem description, brief description of the entities, and their attributes. The following properties should be considered when submitting the final work: 1. Uniqueness: new and no duplicates 2. Originality: Creative effort invested by group members into the requirements that gives them a new quality or character. The problem statement contains indicators for freshness of aspect, design, or style. 3. Completeness: The state of being complete. 4. Readability: The ease in which anyone can read and understand the work. 5. Creativity: Artistic or intellectual inventiveness. We can define creativity as innovation which refers to the introduction of novel things. Your final work should include the following: PART I: Project description and data modeling (total points 20) 1. Write an executive summary of the business case ( Maximum of one page, 5 points) Submit your project description electronically to Bb under BbProjectProjectDescription 2. Draw the Entity-Relationship model by showing all necessary attributes and identifiers and relationships (10 points) 3. Construct a data dictionary table of all attributes in tables (5 Point) PART II: Implementation (Total points 80) 1. Create the tables identified in part I in SQL+ under Oracle (10 points) 2. Insert at least 20 rows in each table, and display the tables. (10 points) 3. Write at least 20 questions to display data from tables. Questions should span all topics covered in class (20 points) 4. Write the corresponding SQL statement for each question in step 3 and execute them. (40 points) Submit the final work to BbProjectFinalProject Each team member must submit a softcopy, and the team must submit one hard copy. CIT365 Project Evaluation Criteria ST Names: Section# Project Title Grade A B C D F Project Management Points: 25 (25%) Demonstrated project management ability, developing the product over time, incorporating appropriate reviews, ending with timely and complete product delivery Points: 20 (20%) Demonstrated project management ability, developing the product over time, incorporating appropriate reviews, ending with timely and mostly complete product delivery. Points: 17.5 (17.5%) Product was mostly developed in the last third of the assigned time but is mostly complete, some appropriate reviews have been incorporated. Points: 15 (15%) Product was entirely developed in the last third of the assigned time and is only partially complete. No reviews have been incorporated Points: 0 (0%) No project management ability demonstrated whatever. Product Development Implementation Points: 25 (25%) The development process employed was selected to ensure a highquality final product. Points: 20 (20%) The development process employed contributed to a quality final product, but there were alternative approaches which would have produced a higher quality product. Points: 17.5 (17.5%) The development process employed delivered a product of acceptable quality but did not substantially contribute to product quality – other approaches would have been more appropriate. Points: 15 (15%) The development process employed was inappropriate for the type of product being delivered. Many other approaches would have been superior. Points: 0 (0%) Development process was entirely haphazard. Product Delivery Points: 40 (40%) The delivered product is of very high quality. Points: 32 (32%) The delivered product was of high quality. Points: 28 (28%) The delivered product was of acceptable quality. Points: 24 (24%) The quality of the delivered product was just below acceptable standards. Points: 0 (0%) The delivered product was of poor quality. Communicate with instructor during the development of the project Points: 10 (10%) Actively liaise with instructor throughout the development of the project. Points: 8 (8%) Moderate liaise with instructor throughout the development of the project. Points: 7 (7%) The delivered product was irregularly liaised with instructor throughout the development of the project. Points: 6 (6%) The delivered product was minimum liaised with instructor throughout the development of the project. Points: 0 (0%) The delivered product was not consulted with the instructor.