Higher Order Thinking Skill Questions
Unit I – Business Computing
1 ABC university has many Departments. Each department has a department code (dcode) and a department name (dname). There are many Professors in the University and a Professor can be a member of many departments. Each Professor has a professor code (pcode) and a name. Each member has a memid and a memstatus. Draw the E-R diagram of the given scenario.
2 Consider the case of banking system of India. Each Bank has many branches and each branch has many employees. Each bank has a name and a bank_code. Each branch has a branch_code, branch_name and location. Employees have empcode, designation and salary. Depict this scenario using an ER model.
3 A school has many students. Each school has its school_code and school_name. Every student has a scholar_no, class and name. Each student has his performance recorded. Performance has pid, subject, marks. Depict the scenario as E-R diagram.
4 Consider two E-R models. Model A consists of two entities and one relationship joining them. The entities are lecturer and course and the relationship is teaches. Model B consists of three entities; the first and the third are the same as above but the second entity is called lecture. The first and second entities are joined by a relationship called gives while the second and the third entities are joined by a relationship called of.
Which two of the following are correct? Briefly justify your answers.
(A) Both models allow a course to have more than one lecture from the same lecturer
(B) Model B is more appropriate if information about all lectures, past and present, is to be stored
(C) Model A does not allow lecture date and time to be stored
(D) Model B leads to more tables than Model A does when translated to the relational model
5 A factory has many employees in shifts. Factory has an id, name and type. Each employee has an employee id (empid), name, gender. An employee may have marital relationship with another employee. Each shift has a shift id (sid) and shift name (sname). Draw E-R diagram for the above scenario.
6 A Research Laboratory has many researchers. All the researchers are categorized in to fellows and associates. Laboratory has a labid and labname. Researchers have researcher id (resid) and name. Fellows are paid salary where as associates are paid stipends. Draw E-R diagram for the above scenario.
7 Bio-Informatics Information:
Each Patient has a unique number, a Patient name (Pname), a Date of Birth (DoB), a Tissue Type (Ttype) and an Indicator(ind) denoting whether the tissue is cancerous or normal. Each Patient Library associates a patient with multiple Tags. Each Tag has a unique tag number (tno) and a nucleotide sequence (nuc_seq). For each Tag in the patient library, a count is given to record the number of times the tag occurs in the library. In general, the same tag can be associated with any number of patients. A Tag may be mapped to a Gene. Each gene has a unique gene name (gname) and a type. In general, multiple tags may be mapped to the same gene. However, two genes cannot be mapped to the same tag. Draw E-R diagram for the above scenario.