Assume that you have been hired as a database administrator in a new colege hile

Question

Assume that you have been hired as a database administrator in a new colege hile designing the database, you have encountered an entity Student that is having a multivalued attribute, named as Stu_Subject. Multivalued attributes would create difficulty in record searching. How would you solve the problem multivalued attributes? [2 marks] (b) What information are store in a transaction log? Please list out four. 4 marks (e) Based on the given Object Oriented Data Model, describe the business rules that [4 marks] reflect the relationships between LECTURER and FACULTY LECTURER Lec ID Name DOB Gender Age Salary Works At FACULTY Fac ID Name Staff LECTURERM Dean LECTURER1 FACUL Dean Of ACULTY1

Explanation / Answer

(a) Multivalue Attribute

Entities - Assume we have following attributes in Student table. We create new table as StudentSubject whose primary key is StudentID .

Student(StudentID,Name,Address)

StudentSubject(StudentID,Stu_Subject)

For every mutivalued attribute we need to create a new table . Underliend are primary keys.

(b) The transaction log file contains following data:

1.Current LSN

2. Operation

3.Context

4. TransactionID

(c) Business rules for relationships

1. One Faculty can have one or many Lecturers

2. One Lecturer is associated with one and only one Faculty.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---