C1025 SQL Term 3 2007 Assignment – part 1
Hi! I want to share another assignment that I get during my International Diploma in Computing course from Informatics Computer School Singapore. This assignment is from C1025 Structured Query Language Module.. The main objective is that we have to make a Library database and then use that database as a reference to explain common terms in Relational Database System.
The Question:
Write detail notes to explain the following terminologies.
(a) Database [15]
(b) Tables [20]
(c) Attributes [10]
(d) Tuples [15]
(e) Relational Database [15]
(f) Primary Keys [10]
(g) Composite Primary Key [5]
(h) Foreign Keys [10]
Requirements for this paper are as follow:
• Design and draw a database of 3 to 5 tables, to be used to explain the above terminologies. These tables must be realistic and related to indicate your understanding of RDB.
• Your mock LIBRARY database must show the fields with realistic data.
• You must display your in-depth understanding of the terminologies by their characteristic, purpose, advantage and disadvantages of their use (if any).
• Use the mark allocation to serve as a guide for the volume and quality of your answer
My Answer: Click here to read the full post…
