Homework answers / question archive / Module Intended Learning Outcome: On completion of the module, students are expected to be able to: Apply database design techniques to design relational data models typically used in business application systems   Lesson Intended Learning Outcome: On completion of this lab, students are expected to be able to: State the features of Three-level Architecture

Module Intended Learning Outcome: On completion of the module, students are expected to be able to: Apply database design techniques to design relational data models typically used in business application systems   Lesson Intended Learning Outcome: On completion of this lab, students are expected to be able to: State the features of Three-level Architecture

Computer Science

Share With

---

Module Intended Learning Outcome:

On completion of the module, students are expected to be able to:

• Apply database design techniques to design relational data models typically used in business application systems

 

Lesson Intended Learning Outcome:

On completion of this lab, students are expected to be able to:

• State the features of Three-level Architecture.
• State the metadata of an attribute in a relation
• Interpret relational structure
• Differentiate among the functionality of different relational keys
• Apply relation integrity in the design of database

 

 

TASK:

 

1.         Given the following relations of the scholarship system of a college:

SCHOLARSHIP (ScholarshipNo, ScholarshipName, DonorName)

STUDENT (StudentID, StudentName, ProgrammeCode)

AWARD (ScholarshipNo, StudentID, AwardAmount, AwardDate)

 

Define the following database terms, and give ONE example for EACH term with suitable attribute(s) in the above relations. 

 

(i)   Composite Primary Key;                                       [3 marks]

(ii)  Foreign Key.                                                          [3 marks]

 

2.    Given the following sample data of the STUDENT relation: 

 

StudentID	StudentName	ProgrammeCode
111106234	Mary Liu	IT114105
111108465	Jenny Tam	IT124106
111108778	Tony Wong	IT114105
111109372	Amy Wong	CN128899
111109566	David Chan	BA123453
111109667	Stephen Au	BA224466

 

1. Describe the meaning of metadata.                         [1 mark]

 

1. Give FOUR examples of metadata for the attribute ProgrammeCode in the STUDENT relation.      [4 marks]

 

(iii) Describe the meaning of the following database terms and give a value for each of them using the above sample data given in the STUDENT relation:

 

1. Cardinality;                                                    [2 marks]
2. Degree;                                                           [2 marks]
3. Tuple.                                                             [2 marks]

 

 

3.         SCHOLARSHIP (ScholarshipNo, ScholarshipName, DonorName)

            STUDENT (StudentID, StudentName, ProgrammeCode)

            AWARD (ScholarshipNo, StudentID, AwardAmount, AwardDate)

 

(i)   Describe how the Entity Integrity rule can be enforced in the STUDENT relation.                                                 

                                                                                      [3 marks]

 

            (ii) Describe how the Referential Integrity rule can be enforced in the AWARD relation.

                                                                                                              [6 marks]                                                                                          

 

4.         Name and describe the three levels of the ANSI-SPARC Three-level Architecture.                                                        [9 marks]