All I need is for someone to look at the rubric below and fix what needs to be fixed. Ignore the data dictionary.
| Q1 - Data Dictionary - Attributes | Comments you were asked to use table 4-1 as a guide. Some details are missing in your definitions. |
ill take care of this^^^^ please fix whats below
| Criteria | Ratings | Pts |
| Q1 - entities (correct, complete, correctly labeled & stereotyped) | Comments a number of your entities are not correct. Review these with me before attempting next homework. | 7 / 10 pts |
| Q1 - PK & Attributes (correct, complete, correctly labeled) | Comments naming convention NOT used sub-entities MUST have unique attributes. Attributes that are common belong in the super-type some attributes incorrect | 7 / 10 pts |
| Q1 - Relationships (correct, complete, correctly labeled) | | 10 / 10 pts |
| Q1 - Relationships (binary and unary exist, correct) | Comments unary is missing | 7 / 10 pts |
| Q1 - Relationships (super and sub-type exist, correct) | Comments do NOT include cardinality on this type of relationships use correct symbols for this type of relationship | 7 / 10 pts |
| Q1 - Cardinality (correct, complete, correctly labeled) | | 9 / 10 pts |
| Q1 - Diagram Logic (correct, complete) | Comments missing essential relationships. Linking almost all entities to day distorts logic of the ERD. | 5 / 10 pts |
| Q1 - Data Dictionary - Attributes | Comments you were asked to use table 4-1 as a guide. Some details are missing in your definitions. | 14 / 20 pts |
| Q1 - PRIMARY KEYS - correct in each entity, clearly identified | Comments Attributes selected as PK must guarantee unique values for each instance. Therefore some of your Pks are not correct | 7 / 10 pts |
| Total Points: 73 |
Alarm w c Short-Term Goal W User 5 Notification W Goal Type Type Medium-Term Goal w Goal Type Day s Notfy Day Long-Term Goal w Goal Type School s D College Timeframeww LocationSD Activities User: Name- determine who the individual user is short-Term Goal: Goal Type-detemine what short-term goal the user will have Medium-Term Goal: Goal Type-determine what medium-term goal the user will have Long-Term Goal Goal Type determine what long-term goal the user wil have Notification: Alarm- determine if notification is alarm for the user. m Goal Type Type- determines if it's alarm, reminder or notification Alarm: Alarm-detormines what alarm neaded to notify the user User. Name-determine who the individual user is Short-Term Goal Gaal Type-determine what short-term goal the user will have Medium-Term Goal: Goal Type determine what medium-term goal the user will have. Long-Term Goal: Goal Type determine what long term goal the user will have Notification: Alarm-determine if notification is alarm for the user Type-determines if it's alarm, reminder or notification Alarm: Alarm-determines what alarm needed to notify the user Reminder: Notify-notify the user when they need to be reminded of something. Day. Day-determines the day of the month for the user Month-determines what month it is for the user. Year- determines what year it is for the user School Colege-determines what college the user visits on whatever day Class-determines where the class is for the day Assignment-determines if the user has any assignments for the day Entity Name Location: Location-where the user is at a specific time of day Activities: Type-what type of activity the user is doing Entity Location- where the user is at & specific time of day Time-what time of day and how long TimeFrame: Time-what time of day and how long attributoe STRONG RELATIONSHIP W: WEAK RELATIONSHIP D:DISIOINT Relationship with labe = OVERLAP U-UNRAY RELATIONSHIP -BINARY RELATIONSHIP Entity Name Double box weak Alarm w c Short-Term Goal W User 5 Notification W Goal Type Type Medium-Term Goal w Goal Type Day s Notfy Day Long-Term Goal w Goal Type School s D College Timeframeww LocationSD Activities User: Name- determine who the individual user is short-Term Goal: Goal Type-detemine what short-term goal the user will have Medium-Term Goal: Goal Type-determine what medium-term goal the user will have Long-Term Goal Goal Type determine what long-term goal the user wil have Notification: Alarm- determine if notification is alarm for the user. m Goal Type Type- determines if it's alarm, reminder or notification Alarm: Alarm-detormines what alarm neaded to notify the user User. Name-determine who the individual user is Short-Term Goal Gaal Type-determine what short-term goal the user will have Medium-Term Goal: Goal Type determine what medium-term goal the user will have. Long-Term Goal: Goal Type determine what long term goal the user will have Notification: Alarm-determine if notification is alarm for the user Type-determines if it's alarm, reminder or notification Alarm: Alarm-determines what alarm needed to notify the user Reminder: Notify-notify the user when they need to be reminded of something. Day. Day-determines the day of the month for the user Month-determines what month it is for the user. Year- determines what year it is for the user School Colege-determines what college the user visits on whatever day Class-determines where the class is for the day Assignment-determines if the user has any assignments for the day Entity Name Location: Location-where the user is at a specific time of day Activities: Type-what type of activity the user is doing Entity Location- where the user is at & specific time of day Time-what time of day and how long TimeFrame: Time-what time of day and how long attributoe STRONG RELATIONSHIP W: WEAK RELATIONSHIP D:DISIOINT Relationship with labe = OVERLAP U-UNRAY RELATIONSHIP -BINARY RELATIONSHIP Entity Name Double box weak
