· 8 years ago · Feb 17, 2018, 05:40 AM
1# WARM UP OUTLINE
2## Due:
3___Project Title: Project Management System -- PMS___<br/>
4___Due: February 14, 2018___<br/>
5___Points: 6%___ <br/>
6## To be handed in:
7* A soft copy report with the E/R model for the DB. Needs assumptions and constraints made. List all the relations, attrubute, and data types considered. Identify the keys on each table and show the relationships. Also needs a formulization of the SQL statements used and their results.
8* Project report needs:
9 1. Coverpage,
10 2. SIGNED BY EVERY STUDENT: The expectation of originality form.
11 3. Team ID given by stan, names and student IDs
12
13## Intro info:
14
15
16Develop a web based database application that will display info about student's projects, teams, demotimes etc.
17Needs MySQL DBMS and requires you to submit a report describing stems, codes and DB instance to evaluate queries, transactions and display data.
18
19Database needs a table of:
20Students (_SID_, Name, gender, email),
21Projects (_PID_, Name),
22Teams (_TID_, LeaderID, NoOfMembers),
23Members (_SID_, _TID_, dateJoined,role),
24Demos (_SID_, _TID_, Date, time, grade).
25
26Members are a __one to many__ relation
27* Every student has to be a member of exactly one team.
28* Each team is assigned one demo slot, identified by date and time.
29* No team may have more than 4 members.
30* The leader of a team is unique if exists. It will be null otherwise.
31
32## The Software must:
33* Do inserts
34* Do deletes
35* Do updates
36* Create data to be put into the database
37* Verify that the DB has suitable and enough number of tuples so that queries will result in meaningful and reasonable sized outputs.
38See warm-up outline for details
39* Only SQL, no GUI
40* Support queries of:
41 1. Which student(s) are not a member of any teams
42 2. List each team's members. (outline says for each team, list members)
43 3. Who was not present in the team's demo
44 4. List the teams which have <4 members.
45 5. Given a TID, list the names of members
46 6. given a date, list all teams that have demos on a certain day.
47 7. For each incomplete(<4) team, list the team id and the ammount of members needed to fill.
48 8. select student name or ID and find team ID.
49 9. select student name or ID and find the teamate's names and SIDs.