ICT321_SEPwSolution - ICT321 Database Systems Modelling...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
ICT321 Database Systems: Modelling & Design (Specimen Exam Paper)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ICT321 SEP 1 Answer ALL 7 questions. Questions 1 to 6 are each worth 10 marks. Question 7 is worth 40 marks. QUESTION 1 1.1 Which of the following are examples of Data and which can be considered Information? State what distinguished Data from Information. a. Your age b. Employment status of 2006 cohort by course enrolled c. Average taking of chicken rice stall in UniSIM canteen d. Blood pressure of lecturer e. Price of textbook for ICT321 f. Percentage of ICT321 students enrolling for ICT322 g. Student X’s ICT321 grade h. Number of students scoring above 70% in ICT321 [8 marks] 1.2 Explain why context is important in determining what information to keep. [2 mark] QUESTION 2 Draw an entity-relationship diagram (ERD) for an event organiser to keep information about the event bookings of their customers. A customer will book an event to be held in a facility (eg sports hall, conference room, dance hall, etc), specifying the event date, budget and number of guests/participants. Similar facilities are sometimes available in more than one location. Some customers, such as sports coaches, may make bookings for more than one event. (Make reasonable assumptions about the basic data to be kept on customers, locations and facilities) [10 marks]
Background image of page 2
ICT321 SEP 2 QUESTION 3 3.1 Use the Training Records table below to illustrate a) an insertion anomaly and b) a deletion anomaly. You can assume the sample table contains all the data. Employee Course Fee Date Duration Jones Word $500 20 Apr 3 Marion Powerpoint $750 18 May 4 Peter Word $500 20 Apr 3 Jones Excel $600 30 Apr 4 Greene Excel $600 30 Apr 4 [5 marks] 3.2 The following table represents details of student assignment grades. student_id course_code assignment_no grade s01 c4 2 78 s05 c2 1 78 s09 c2 2 null s09 c3 1 60 s09 c3 2 50 s09 c4 2 50 s57 c4 2 77 Write an SQL query to give: a) the student identifiers of all students who achieved a grade of between 60 and 70, inclusive. [1 mark] b) the course code and the total number of assignments for each course. [2 marks] c) the course codes of any courses where a student has a grade for assignment 2. [2 marks]
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ICT321 SEP 3 QUESTION 4 The Movies database consists of three tables as follows : movie ( id , title, yr, score, votes, director ) actor ( id, name) casting( movieid , actorid , ord) This database features two entities (movies and actors) in a many-to- many relation. Each entity has its own table. A third table, casting , is used to link them. The relationship is many-to-many because each film features many actors and each actor has appeared in many films. movie
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/06/2010 for the course IT ICT321 taught by Professor Tan during the Spring '10 term at Singapore Institute of Management.

Page1 / 13

ICT321_SEPwSolution - ICT321 Database Systems Modelling...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online