Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ER Modeling Relationships - I have the list of tables and columns and the scenario but I need help with assigning relationships between the tables.

ER Modeling Relationships -

I have the list of tables and columns and the scenario but I need help with assigning relationships between the tables.

Please find the scenario and tables below

image text in transcribed

Tables:

image text in transcribed

The SolarPV provides certification services of PV product. Each service is uniquely identified by an ID. We record the service name, description, type, referenced test standard, whether or not factory inspection is required, and the inspection frequency if applicable. A factory inspection record contains the report number, the location inspected, inspection date, inspection sequence, next inspection date, certificate number, inspector, and findings. A certificate record contains is uniquely identified by a certificate number; and contains the client, the corporate location, the test report number, project handler, the associated standard, the product, and the certificate issue date. There are a number of test standards, each having an ID, a name, description, and the published date. Information about a PV product include a unique model number, name, type, fire class, and maximum system voltage. A product can be manufactured at multiple locations. When a client requests a service, a SolarPVmanager sends a quote. Each quote is uniquely identified by a quote number. The quote also contains an amount, issue date, expiration date, the issuer name, and a number of line items. Each quote line item is identified by a line number and contains the task description, ref service, and the price. For each client, we assign an ID and record the name, the type (manufacturer, distributor, etc.).A client can have multiple locations and multiple contact persons. A location bas.a name, address, phone, type (factory, corporate, etc.). Each client contact has a unique username, a password, first name, middle name, last name, job title, email, office phone, cell phone. Client Location Service Test Standard product clientR lecationlR clientName slientUR clientType address1 servicelD description Fl required Fl frequency test standard ID description published date address2 fire class maximum system voltage country cellphone fax number Factory Inspection Quote Prod location ID uct Factory Certificate Line Item report # date servicelD. price report# contact name test standard sequence cert issue date

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Optimizing Data Collection In Warzones

Authors: Aaget Aamber

1st Edition

B0CQRRFP5F, 979-8869065902

More Books

Students also viewed these Databases questions

Question

16 ww 9

Answered: 1 week ago

Question

The nature and importance of the global marketplace.

Answered: 1 week ago