Homework answers / question archive / Group Project Description and Rubric You are assigned to a group of 4 students to conduct a database project during the semester

Group Project Description and Rubric You are assigned to a group of 4 students to conduct a database project during the semester

MS Access

Share With

---

Group Project Description and Rubric

You are assigned to a group of 4 students to conduct a database project during the semester. Each group is to identify a real-world database development project. You are required to analyze, design, and implement a prototype database system using MySQL for your identified project. The subject could be an organization that you are employed with or an organization you are observing. Contacts with a representative from the particular organization are encouraged but not required.

If the students did not participate in any parts of the group project, they will receive a 0 for the final group project grade!

The deliverables of the project are (TOTAL SCORE: 100 pts):

1. mid-term presentation (5 pts)
2. final presentation(60pts)
3. project report (30 pts)
4. individual team member rating (5 pts)

1. A mid-term presentation to the instructor (5 pts)

1. A general description or the introduction of the company where the group project is being conducted, which includes: business goals of the company and products/services provided by the company etc. (1 pt)
2. Identify and report user requirements for your group project (1 pt)
3. (Conceptual Data Modeling) Draw a basic Entity-relationship diagram based on user requirements described in item b (3 pts)

2. Final presentation and code demonstration (power point or equivalent).Each group is given 10 min. to present your project to the class and demonstrate your database implementation. One or two representatives from each group must present. Must contain the following: (60 pts)
   1. A General description or a introduction of the company where the group project is being conducted, which includes: business goals of the company and products/services provided by the company etc. (2 pts)
   2. Identify and report user requirements for your group project. (8 pts)
   3. (Conceptual Data Modeling) Draw Entity-relationship diagram based on user requirements described in item 2 (20 pts).
   4. (Logical Database Design) Convert Entity-relationship data (ERD) model into a relational data model (10 pts).
   5. (Implementation in MySQL) Implement relations in the relational data model developed in item 4 by using DDL and DML in MySQL. Populate sample data into these tables (20 pts): (1). Tables, columns, keys, etc. with at least 20 rows of data per table. (10 pts); (2). 5 SQL Queries inclusive of at least 3 JOINs; (5 pts); (3). 2 Views and 2 Stored procedures. (5 pts)

 

3. A project report documents the process and the results of your group project. The report should have at least the following: (30 pts)
   1. General description (1 pts)
   2. User requirements (4 pts)
   3. Conceptual Data Modeling (10 pts)
   4. Logical Database Design (5 pts)
   5. Implementation in MySQL (10 pts)

 

4. Individual team member (5 pts)