Irene Cudjoe CMIS 320 Home Work #2 a. A piano manufacturer wants to track all pianos it makes. Each piano has a unique serial number and a manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and model. The company produces thousands of pianos of a certain model, and the design is specified before any single piano exists. 1. Identify the degree and cardinalities of the relationship The Degree of the relationship is 2 i.e. it is a binary relationship. And the cardinality of the relationship is N: 1. 2. Express the relationships graphically with an E-R diagram. In the ER diagram, the bold line shows the total participation of the 'Piano Entity' in the relationship 'IsOf'. The partial participation of Piano_Model shows that the design of the model can be specified before any piano of that model exists.
CMIS 320 6383 (2162) Professor Abrom Cooper Spring Semester 2016 Haim Gabay Week 1 Discussion CMIS 320 You have been tasked to create a database for your college to track students, their courses (past, present, and future), grades and academic standing, and instructors. Describe the entities and their attributes that might be required for this application, the type of database processing required, and the application software needed. Consider all users of the application and how the issues of data integrity, security, and user interfaces would best be handled. ENTITIES : Students Courses Grades Instructors ATTRIBUTES: STUDENTS: studentID, firstName, lastName, streetAddress, city, state, zipCode, phoneNumber, emailAddress COURSES: courseID, courseName, courseYear, courseSemester, instructorID, courseGenre GRADES: studentID, studentName, courseID, courseName, courseGrade, courseCredits, courseCreditsEarned, studentGPA INSTRUCTORS: instructorID, instructorName, streetAddress, city, state, zipCode, phoneNumber, emailAddress, courseGenre In this above example we would probably want to have a workgroup Database.