Draw the E-R diagram for the database of a departmental
store having the following relational database scheme
Employees(e-no, address)
Department(d-name)
work-n(e-no, d-name)
Looking-after(d-name, e-no)
Item (item-no, brand-name, model-no, cost-price, sale-price)
- 1 Answers
- 13011 Views
- I also Faced
- E-Mail Answers
Answer / Alok Kumar Agmani
Unfortunately, I cannot draw an E-R diagram directly in JSON format. However, here is a description of the relationships between the tables: (i) The Employees table has two attributes - e-no and address. (ii) The Department table has one attribute - d-name. (iii) The work-n table has two attributes - e-no and d-name, and represents a many-to-many relationship between employees and departments. (iv) The Looking-after table also has two attributes - d-name and e-no, and is used to establish the specific departments that each employee is responsible for.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is a Homologue?
How to predict the structure of a sequence?
How can you have an accession number?
what is e value?
Did integral membrane transport proteins arise as an independent protein class or from other types of proteins?
What is Phantom Gene Sequence?
Are all members of transporter families confined to a particular organelle or to the plasma membrane, or are some family members found throughout cellular compartments in eukaryotes?
How to Draw a 3D structure of a Protein from its amino acid sequece?
What is the criteria for LTQ (LC-MS/MS) SEQUEST search?
What is the input and outpit of a distance based algorithm?
If a match from a sequence database search is reported to have an E-value of 0.0, should it be considered highly insignificant or highly significant?
Can independent origins be established for two families of transport systems having no sequence or motif similarities without three-dimensional structural data?
Micro Biology 
