Computers and Technology, 19.03.2021 21:30 kari41434

For each of the descriptions below, perform the following tasks: i) Identify the degree and cardinalities of the relationship.

ii) Express the entities and the relationships with attributes in each description graphically with an E-R diagram

A piano manufacturer wants to keep track of all the pianos it makes individually. Each piano has an identifying serial number and a manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and a name. In addition, the company wants to maintain information about the designer of the model. Over time, the company often manufactures thousands of pianos of a certain model, and the model design is specified before any single piano exists. (20p)

A piano manufacturer (see (e) above) employs piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by at least two technicians (identified by their employee number). For each separate inspection, the company needs to record its date and a quality evaluation grade. (14p)

The piano technicians (see (f) above) have a hierarchy of reporting relationships: some of them have supervisory responsibilities in addition to their inspection role and have multiple other technicians report to them. The supervisors themselves report to the chief technician of the company. (10p)

A vendor builds multiple types of tablet computers. Each type has a type identification number and a name. The key specifications for each type include amount of storage space and display type. The company uses multiple processor types, exactly one of which is used for a specific tablet computer type; obviously, 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. (13p)

Each individual tablet computer manufactured by the vendor (see h above) is identified by the type identification number and a serial number that is unique within the type identification. The vendor wants to maintain information about when each tablet is shipped to a customer. (17p)

Each of the tablet computer types (see (h) above) has a specific operating system. Each technician the company employs is certified to assemble a specific tablet type â operating system combination. The validity of a certification starts on the day the employee passes a certification examination for the combination, and the certification is valid for a specific period of time that varies depending on tablet type â operating system combination. (11p)

Grading Schema:

1)Correct answer for degree in i) â 1p

2)Correct answer for cardinalities in i) â 1p

3)Entity with complete set of attributes including key attributes +4p

4)Incomplete set of attributes â (minus)-1p

5)Absence of key attributes if they defined â (minus)-1p

6)No or wrong attributes â (minus)-1p

7)Relationship with attributes +4p

8)Wrong left arrowhead â (minus)-1p

9)Wrong right arrowhead â (minus)-1p

10)Absence of relationship attributes â (minus)-1p

11)Relationship without attributes +3p

12)Wrong left arrowhead â (minus)-1p

13)Wrong right arrowhead â (minus)-1p

Answers: 3

Show answers

Answers

Answer from: orlando19882000

attached below in the explanation and the diagrams attached

Explanation:

question

i) identify the degree and cardinality of the relationship

ii) Express the entities and the relationships with attributes in each description graphically with an E-R diagram

i) The degree and cardinality of the relationship

The entities PIANO, MODEL and DESIGNER have a degree of two i.e. Binary relationship The cardinality of the entities PIANO, MODEL and DESIGNER have a relationship of ONE-to-many

ii) description graphically with an E-R diagram

The E-R diagrams show that The degree of the relationship for the entities PIANO, MODEL, and DESIGNER is two(2). and also shows that there is a One-to-Many cardinality available in the entities PIANO, MODEL, and DESIGNER

E-R diagram Attached below

i) The degree and cardinality of the relationship

entities PIANO and Technician have a degree of two ( 2 ) ; i.e. a Binary relationship The cardinality of the entities PIANO, and TECHNICIAN have a relationship of Many-to-Many.

ii) Graphical description with an E-R diagram

The diagram describes/ shows that, entities PIANO and Technician have a degree of two ( 2 ) ; i.e. a Binary relationship and also The cardinality of the entities PIANO, and TECHNICIAN have a relationship of Many-to-Many.

E-R diagram attached below

i) Degree and cardinality of the entity Technician

The entity TECHNICIAN has a degree one, i.e. a unary relationship. The cardinality of the entity TECHNICIAN have the relationship of One-to-Many.

ii) E-R diagram attached below

i) Degree and cardinality of the relationship

The entities TABLET TYPE and PROCESSOR TYPE have a degree of two(2) , i.e. a binary relationship The cardinality these entities TABLET TYPE, and PROCESSOR TYPE have is a Many-to-Many relationship

ii) E-R diagram attached for TABLET TYPE, PROCESSOR TYPE is attached below

i) Degree and cardinality of the relationship

The entities TABLET TYPE, TABLET COMPUTER, and CUSTOMER have a degree of two(2) ; i.e. a binary relationship. The cardinality these entities TABLET TYPE, TABLET COMPUTER, and CUSTOMER have is a One-to-Many relationship

also the shipment to the customer is multiple hence the relationship can be said to be Many-to-Many relationship

also The attribute Shipping Date will become an attribute of that M: M relationship.

ii) The E-R diagram for TABLET TYPE, TABLET COMPUTER, CUSTOMER is attached below

i) Degree and cardinality of the relationship between TABLET TYPE, TECHNICIAN

The entities TABLET TYPE, and TECHNICIAN have a degree of two(2); i.e. a binary relationship. The cardinality these entities TABLET TYPE, and TECHNICIAN have is a Many-to-Many relationship

ii) E-R diagram attached below

For each of the descriptions below, perform the following tasks:

i) Identify the degree and cardina

Answer from: Quest

it can either be 2. or 4. : ) tell me if i'm wrong or right

Answer from: Quest

the answer is d. splog

Another question on Computers and Technology

Computers and Technology, 22.06.2019 10:40

Program using c++ only on visual studio pig is a simple two player dice game, played with one die. the first player to reach or surpass 50 is the winner. each player takes a turn rolling the dice. they add to the pot with each roll, having to decide to roll again and increase the pot, or cash out. the risk being they could lose the amount they’ve accumulated into the pot. the rules for each player’s die roll. 1. roll the dice. a. if user rolled a 1, i. the pot gets set to zero ii. the other player goes to step 1. b. a roll of 2-6 is added to the pot. 2. user can choose to hold or roll again. a. choice roll. return to step 1. b. choice hold. i. increment player score by the pot amount. ii. pot gets set to 0. iii. second player gets to roll and goes to step 1. program requirements: ● before each opponent begins ○ output the score for the person and the computer. ○ output the opponents whose turn is beginning and ask the user to hit enter to continue. ● with each dice roll. ○ output the die value, and amount of the round pot. ○ if it’s the users roll ask if they want to roll again ( r ) or hold ( h ). your program should allow r, r, h or h as valid input. if input is anything else, ask the user again until valid input is obtained. ○ the ai will continue playing until the round pot is 20 or more. ● once a player’s score is greater or equal to 50 then they have won, it will no longer ask if they want to keep rolling the die or not. ● once there is a winner ○ score totals are output along with who the winner was. user or computer ○ player is asked if they want to play again y or n. valid input should be y, y, or n, n. ● when a new game starts the starting roll goes to the player that did not roll last. if the user rolled last in the previous game, then the computer rolls first and vice versa. when the program first begins, the player will make the first roll of the first game. development notes : ● you will need a way to roll dice in your program. the rand() function works well, but returns an integer. if we want numbers 0 – 9 we can get the value modulus 10. ● call srand() with a value to seed it. it’s common to seed it with the current computer clock, include ctime, and then call srand(time(

Answers: 1

Answer

Computers and Technology, 23.06.2019 06:30

Who can provide you with a new password when you have forgotten your old one? your provide you with a new password in case you forget your old one.

Answers: 3

Answer

Computers and Technology, 23.06.2019 11:00

Sports and entertainment class, your goal is to increase attendance and make a profit for a game by getting your team on a winning track with total salaries less than $3,000,000

Answers: 3

Answer

Computers and Technology, 23.06.2019 18:30

Janice recently received her college degree and is looking for a job. she is worried that since she just finished school, she will be required to repay her perkins and direct subsidized loans immediately. janice pulls out the paperwork she signed and reviews it again for repayment information. after reading all of the information, janice discovers that

Answers: 2

Answer

You know the right answer?

For each of the descriptions below, perform the following tasks: i) Identify the degree and cardina...

Questions