This is aSystem analysis and project management class assignment. Masters level. This project has 3 phases. Phase 1 and 2 has been completed. I only need phase 3. I will upload the project sheet, 1...

1 answer below »

View more »
Answered 5 days AfterNov 24, 2024

Answer To: This is aSystem analysis and project management class assignment. Masters level. This project has 3...

Shubham answered on Nov 30 2024
5 Votes
Interface Design

Database Design
1. Users Table
Attributes:
· user_id (Primary Key)
· username (Unique)
· email (Unique)
· password
· preferences (JSON or text format to store user-specific preferences)
· availability (JSON or text format to store availability details)
· created_at (Timestamp)
· updated_at (Timestamp)
Constraints:
· username and email are unique.
· email must be in valid em
ail format.
· password is encrypted for security.
2. Activities Table
Attributes:
· activity_id (Primary Key)
· activity_name
· activity_type (e.g., outdoor, indoor, recreational, etc.)
· description
· duration (time in hours or minutes)
· location (optional)
· tags (JSON for storing activity categories or preferences)
· created_at (Timestamp)
· updated_at (Timestamp)
Constraints:
· activity_name must be unique.
· duration should be a positive integer.
· created_at and updated_at are automatically generated.
3. User_Activities Table
Attributes:
· user_activity_id (Primary Key)
· user_id (Foreign Key referencing Users)
· activity_id (Foreign Key referencing Activities)
· status (e.g., planned, completed, canceled)
· scheduled_date (Timestamp)
· feedback (optional text for user feedback on activities)
· created_at (Timestamp)
· updated_at (Timestamp)
Foreign Keys:
· user_id references Users(user_id)
· activity_id references Activities(activity_id)
Constraints:
· The combination of user_id and activity_id must be unique to prevent duplicate entries for the same user-activity pair.
4. Emails Table
Attributes:
· email_id (Primary Key)
· user_id (Foreign Key referencing Users)
· subject
· body
· received_date (Timestamp)
· status (e.g., read, unread)
· priority (High, Medium, Low)
· created_at (Timestamp)
· updated_at (Timestamp)
Foreign Keys:
· user_id references Users(user_id)
Constraints:
· subject and body are required fields.
· received_date must be a valid timestamp.
5. Reports Table
Attributes:
· report_id (Primary Key)
· user_id (Foreign Key referencing Users)
· title
· content (Text or JSON for storing structured report content)
· created_at (Timestamp)
· updated_at (Timestamp)
Foreign Keys:
· user_id references Users(user_id)
Constraints:
· title should be unique for each user.
· content is a required field.
6. Feedback Table
Attributes:
· feedback_id (Primary Key)
· user_activity_id (Foreign Key referencing User_Activities)
· rating (Numeric scale, e.g., 1-5)
· comments (optional text for additional feedback)
· created_at (Timestamp)
Foreign Keys:
· user_activity_id references User_Activities(user_activity_id)
Constraints:
· rating must be an integer between 1 and 5.
· comments are optional but can be stored as text.
7. Task Prioritization Table
Attributes:
· task_id (Primary Key)
· user_id (Foreign Key referencing Users)
· task_name
· priority (High, Medium, Low)
· due_date (Timestamp)
· status (e.g., pending, completed)
· created_at (Timestamp)
· updated_at (Timestamp)
Foreign Keys:
· user_id references Users(user_id)
Constraints:
· task_name must be unique for each user.
· due_date must be a valid timestamp.
8. Activity Recommendations Table
Attributes:
· recommendation_id (Primary Key)
· user_id (Foreign Key referencing Users)
· activity_id (Foreign Key referencing Activities)
· score (numeric score for the recommendation)
· reason (optional text explaining why this activity is recommended)
· created_at (Timestamp)
Foreign Keys:
· user_id references Users(user_id)
· activity_id references Activities(activity_id)
Constraints:
· score must be between 1 and 10.
· reason is optional but can be provided as text.
Class Diagram
Software Design
Method Name: Task Prioritization with Feedback()
Class Name: TaskManager
ID: Task Prioritization #1
Clients (Consumers): Project Manager
Associated Use Case(s): Task Scheduling, Task Management
Description of Responsibilities: Calculates urgency of tasks and prioritizes them based on user-defined weights for ensuring critical tasks that are addressed.
Arguments Received: List of Tasks, Current Time, Priority Weights
Type of Value Returned: Sorted List of Tasks
Pre-Condition(s): User provides a list of tasks, current time, and priority weights.
Post-Condition(s): A list of tasks...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30