Question: Please draw the enhanced entity relation diagram with subclass and superclass structure for three types of accounts: Phone, Printer and Router For Phone type, it

Please draw the enhanced entity relation diagram with subclass and superclass structure for three types of accounts: Phone, Printer and Router

For Phone type, it has the following attributes device_ID, serial_number, device_type, IP_address, operating_system, phone_number

For Printer type, it has the following attributes device_ID, serial_number, device_type, IP_address, operating_system, printer_identifier

For Router type, it has the following attributes device_ID, serial_number, device_type, IP_address, operating_system, WAN_provider, circuit_type

For each computing device, it may have many records of DeviceHistory. The DeviceHistory entity type includes the following attribute: device_id, start_date, record_action, modifying_user

For each Printer, it may print multiple documents. The Document entity type includes the following attribute: document_id, num_of_words, topic and num_of_copies

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!