Course Hero Logo

ITS232 SEP2014 ANSWER.pdf - CONFIDENTIAL 1 CS/SEP...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 5 out of 11 pages.

CONFIDENTIALCS/SEP 2014/ITS232/250© Hak Cipta Universiti Teknologi MARACONFIDENTIALUNIVERSITI TEKNOLOGI MARAFINAL EXAMINATIONCOURSE:INTRODUCTION TO DATABASE MANAGEMENTSYSTEMSCOURSE CODE:ITS232/250EXAMINATION:SEPTEMBER 2014TIME:3 HOURSANSWER SCHEME
CONFIDENTIAL2CS/SEP 2014/ITS232/250© Hak Cipta Universiti Teknologi MARACONFIDENTIALPART A (20 MARKS)1.B6.B11.B16.D2.C7.C12.B17.C3.A8.B13.C18.D4.B9.C14.D19.B5.B10.A15.D20.C
CONFIDENTIAL3CS/SEP 2014/ITS232/250PART B (60 MARKS)QUESTION 1a)Briefly explain anyTWO(2)reasons why database design is important.(2 marks)
© Hak Cipta Universiti Teknologi MARACONFIDENTIAL
b)Briefly explain anyTWO(2)disadvantages of database management system (DBMS).(2 marks)
QUESTION 2i-Learn Portal is a database application system that allows students to learn via online.Students can download notes, take online assessment, perform discussion with theirlecturers as well as group members and also evaluate their subjects and learning facilities.Answer the following questions based on the above statement:a)IdentifyTHREE(3)entities from the scenario.(3 marks)Any three possible entities:up to the lecturer’s discretionb)ProvideTWO (2)possible business rules from the answer that you have given inQuestion 2(a).(4 marks)Any two possible business rules:up to the lecturer’s discretionQUESTION 3a)Describe anyTHREE (3)characteristics of a relational table.(6 marks)
CONFIDENTIAL4CS/SEP 2014/ITS232/250© Hak Cipta Universiti Teknologi MARACONFIDENTIALEach column has a specific range of values known as the attribute domain.The order of the rows and columns is immaterial to the DBMS.Each table must have a primary key that uniquely identifies each row.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 11 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Mis Zahra Ali
Tags
Database management system, Hak Cipta Universiti Teknologi MARA

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture