CSCI 585 - Assignment 1 Rubrics ER Diagram Total Marks: 6 marks Distribution of marks is shown in the table below: Submission Requirements Marks Allotted ER Diagram (.jpg/ .png) 5 marks README.txt 1 mark FILE FORMAT AND NAMING CONVENTIONS • ER Diagram should be either .png or .jpg. • Name of the description file should be “README.txt”. **Please Note - Since this is the first assignment, marks won’t be deducted on the basis of naming conventions. But from next time, please follow the EXACTsubmission guidelines. We will start taking off points for not following the submission requirements. Rubrics - ER Diagram Following are the considerations we made during grading your assignments: 1. Fully depicted entities, attributes and relationships mentioned in problem description. Some of the required entities are mentioned below. 1. That will be worth 3 points. 2. If any one is wrong, -1 would be deducted. 3. If a student got all of the following wrong, we deduct 3 points. 2. PK and FK should be marked (-0.5 if missing) 3. All the entities presented in the solution must be there. (-1 if missing) 4. Strong and Weak Relationships must be mentioned. 1. A Strong relationship should be indicated by adding the referencing foreign key to the primary key of the entity. 2. They should be distinguished by dashed and solid lines. (-1 mark if there is no differentiation) 5. Standard and meaningful notations should be there in the ER as discussed in class. **Please Note -Any weird notation will be penalized accordingly. This study source was downloaded by 100000774124144 from CourseHero.com on 09-07-2021 14:51:21 GMT -05:00 https://www.coursehero.com/file/98832531/Rubrics-HW1-Summer-2021pdf/ Th is s tud y r eso urc e w as sha red vi a C ou rs He ro. com Rubrics - README.txt Following are the considerations we made while grading the description file: 1. All assumptions should make sense. If they are not well explained and don’t make sense 0.5 will be deducted for each inconsistent assumption. 2. Incomplete explanation of the design would cost you 0.5 marks. 3. Report should discuss the tradeoff or design decisions that were taken which differed from the ones mentioned in the homework description. **Please Note -This is an exercise to help you think in terms of design decisions that you take when designing large scale databases. It is important to question your decisions, write substantiating statements and discuss the trade-offs in your design. Required Entities (Need not match exactly but valid assumptions must be explained!) Before we present the 2 sample solutions, here is the tabular representation of expected entities and relationships. This may vary according to the valid assumptions you made for your own design. Overall, these cover the entire homework description. Entities Attributes Description Book Check-in and For the library module, a student should be able to check in Check-out and checkout the book Student First Class Citizen Course/Class Language Students will be enrolled in classes. Project Microcontroller Students will be enrolled in projects. (*) For the schedule (mentioned in description) Room Rating Score Students will rate Instructors, Classes and Projects Instructor First Class Citizen, should track “hours taught” in the relation (*) Just check for the Instructor - Textbook relation, it can be Textbook approached in different ways. Project* Student For keeping track of items related to the project Parts Vendor, Cost To keep track of the cost of part This study source was downloaded by 100000774124144 from CourseHero.com on 09-07-2021 14:51:21 GMT -05:00 https://www.coursehero.com/file/98832531/Rubrics-HW1-Summer-2021pdf/ Th is s tud y r eso urc e w as sha red vi a C urs eH ero .co m At the bare minimum, following relationships should be present 1. MANY Students can be enrolled in MANY Classes 2. MANY Students can be enrolled in MANY Projects 3. ONE Student can borrow MANY Books from library 4. ONE Student can rate MANY Classes, Projects, Instructors 5. MANY Instructors teach MANY Classes and recommend a TextBook for a Class. 6. ONE/MANY(**)Instructors supervise MANY Projects. 7. MANY Students belongs to ONE ProjectGroup (or Table)(*)which has MANY Parts 8. MANY Parts will be sourced from MANY Vendors * These entities/relationships may vary based on the design. ** Assumption: as it is not mentioned in description Suggested Steps for Evaluating Assignment 1. Check for necessary entities: (-1 for 2 missing total entities and -2 for more): Class, Project, Instructor, Student 2. Check for attributes or entities: (-1 for 2 missing total entities and -2 for more) Language, Library/book, Salary, Suppliers, Textbook, Part, Room, Ra3ting should be shown in the diagram 3. Check for N:M relationships or Bridge entities: (-1 for 2 missing total entities and -2 for more): Project Rating, Class Rating, Instructor Rating, Instructor teaching Class, Teacher prefers Text, Book used in class, Student taking class, Student doing Project 4. CheckSupplier-Part-Tablerelationshipformany-manyrelationship:(-1for2missingtotal entities and -2 for more) 5. Check Primary Key of each entity: (-1 for each missing PK) 6. Check Foreign Key of each entity and check its related 1:N relationship. (-1 for each mistake) This study source was downloaded by 100000774124144 from CourseHero.com on 09-07-2021 14:51:21 GMT -05:00 https://www.coursehero.com/file/98832531/Rubrics-HW1-Summer-2021pdf/ Th is s tud y r es urc wa s sha red vi a C ou rse He ro. com Sample Solution 1 This study source was downloaded by 100000774124144 from CourseHero.com on 09-07-2021 14:51:21 GMT -05:00 https://www.coursehero.com/file/98832531/Rubrics-HW1-Summer-2021pdf/ Th is s tud y r eso urc e w as sha red vi a C ou rse He ro. com Sample Solution 2 This study source was downloaded by 100000774124144 from CourseHero.com on 09-07-2021 14:51:21 GMT -05:00 https://www.coursehero.com/file/98832531/Rubrics-HW1-Summer-2021pdf/ Th is s tud y r eso urc e w as sha red vi a C ou rse He ro. com This study source was downloaded by 100000774124144 from CourseHero.com on 09-07-2021 14:51:21 GMT -05:00 https://www.coursehero.com/file/98832531/Rubrics-HW1-Summer-2021pdf/ Th is s tud y r eso urc e w as sha red vi a C ou rse He ro. com This study source was downloaded by 100000774124144 from CourseHero.com on 09-07-2021 14:51:21 GMT -05:00 https://www.coursehero.com/file/98832531/Rubrics-HW1-Summer-2021pdf/ Th is s tud y r eso urc e w as sha red vi a C ou rse He ro. com Powered by TCPDF (www.tcpdf.org)
欢迎咨询51作业君