Q1. Construct an ER diagram for the given problem definition:
Each of the company operates four departments, and each department belongs to the one company. Each department employs one or more employees and each of the employee works for one department. Each of employees might or might not contain one or more dependants and each dependant belongs to the one employee.
Q2. Illustrate the meaning of the term attribute of an entity? Write down illustrations of simple, composite, single-valued, multi-valued and derived attributes. As well draw the symbols employed for them in the ER diagrams.
Q3. Describe the key control measures which are used to give security to data in the databases.
Q4. Describe the relationship between the data warehousing and data mining.
Q5. Describe the fragmentation transparency, replication transparency and location transparency in the distributed databases.