Lab 2
CMIS 320 Lab 1 Homework
Part 1
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.
Piano-Model:
Cardinality: one-to-many (1:M).
Each piano only has one model, but each model may have multiple pianos.
2. Express the relationships graphically with an E-R diagram.
b) A vendor builds multiple types of tablet computers. Each has a type identification number and a name. The key specifications for each type include amount of storage and display type. The company uses multiple processor types, exactly one of which is used for a specific tablet type. The same processor can be used in multiple types of tablets. Each processor has a manufacturer and a manufacturer's unique code that identifies it.
1. Identify the degree and cardinalities of the relationship.
Processor-Tablet_Type:
Cardinality: one-to-many (1:M).
Each tablet type has one processor, and each processor can be used in multiple tablet types.
Table_Type - Tablets:
Cardinality: one-to-many (1:M).
Each tablet is of one tablet type, and each tablet type has multiple tablets.
2. Express the relationships graphically with an E-R diagram.
Part 2
On this part of the lab I had a hard time figuring out the FTP file transfer but once I was able to do it, everything else got kind of smooth.
Part 1
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.
Piano-Model:
Cardinality: one-to-many (1:M).
Each piano only has one model, but each model may have multiple pianos.
2. Express the relationships graphically with an E-R diagram.
b) A vendor builds multiple types of tablet computers. Each has a type identification number and a name. The key specifications for each type include amount of storage and display type. The company uses multiple processor types, exactly one of which is used for a specific tablet type. The same processor can be used in multiple types of tablets. Each processor has a manufacturer and a manufacturer's unique code that identifies it.
1. Identify the degree and cardinalities of the relationship.
Processor-Tablet_Type:
Cardinality: one-to-many (1:M).
Each tablet type has one processor, and each processor can be used in multiple tablet types.
Table_Type - Tablets:
Cardinality: one-to-many (1:M).
Each tablet is of one tablet type, and each tablet type has multiple tablets.
2. Express the relationships graphically with an E-R diagram.
Part 2
On this part of the lab I had a hard time figuring out the FTP file transfer but once I was able to do it, everything else got kind of smooth.