What's new

Tutorial FREE Chegg Unlock

Status
Not open for further replies.
1619524683670.png

1619524701828.png
 

Attachments

Solution:

Conceptual Model:


In Conceptual model it will consist of entity names and entity relationships

Each Data entities has its own data attributes:

Example:

1619598151146.png

The data attribute of Customer will be customer identification number, few data attributes of vendor will be vendorid, one of the data attributes of orders will be orderid, invoices have incoiceid, product have productid and so on.

CROW'S FOOT ER DIAGRAM

The below diagram shows the entities, attributes and their realtionship with other entities in Primary and foreign Key relationship.

There are one to many, one -to-one relationship between the entities as shown below

1619598169940.png


ENTITY RELATIONSHIP Relational diagram

Here P denotes the Primary Key and F denotes the Foreign Ket relationship with other tables in the given diagram,

There are One-to-Many, One -to-One relationship between the tables as shown below

1619598190338.png
 

Attachments

1. The collected water sample isn't filtered. Will this oversight result in the TDS (total dissolved solids) value being reported too high or too low? Explain.

Ans. High since tds consists of inorganic or organic in molecular or ionoized form

2. The evaporating dish wasn't properly cleaned of a volatile material before its mass was determined. When the sample is heated to dryness the volatile material is removed. As a result of this technique error, will the reported TDS be too high, too low, or unaffected? Explain.

Ans. TDS content would increase, since the sample is heated to dryness, leads to a technical error

4. The sample in the evaporating dish isn't heated to total dryness. How will this error in technique affect the reported value for TDS -- too high, too low, or unaffected? Explain. TSS (total suspended solids) -- too high, too low, or unaffected? Explain.

Ans. Since dish isn't heated to total dryness, TSS would be more since TSS particles cannot pass through a sieve of two micrometers and yet are indefinitely suspended in solution.
TDS wouldnt be much

5. As the sample cools, moisture from the atmosphere condenses on the outside of the evaporating dish before the mass is measured. Will the presence of the condensed moisture increase or decrease the reported TDS in the water sample? Explain.

Ans. TDS would be less since due to the condensation of surrounding water vapour leads to increase in total volume but the tds content would be same, so the reported tds content per volume would be less

6. The sample in the evaporating dish isn't heated to total dryness. As a result of this technique error, will the reported value for total solids (TS) be too high, too low, or unaffected? Explain.

Ans. Total solids content would be high since the volume of volatile liquid decreased, but the total solids would be same, leads to a much higher content TS in the remaining solids

7. Suppose the water sample has a relatively high percent of volatile solide material. How would this have affected the reported mass of:

a. dissolved solids -- too high, too low, or unaffected? Explain.

Ans. Unaffected

b. total solids -- too high, too low, or unaffected? Explain.

Ans. Too high due to the presence high percent of volatile solid material

c. suspended solids -- too high, too low, or unaffected? Explain.

Ans. Unaffected
 
Status
Not open for further replies.

Similar threads

Back
Top