Basic Computer Application Exam Paper free essay sample

A. The primary key of a table serves to uniquely identify individual rows of the table. B. The primary key of a table is allowed to be null. C. Non-key columns are not dependent on the primary key. D. A primary key may not consist of more than one column. E. It is a key that is used as a reference to relate one entity to another entity. 3. __________ is the software that manages and controls access to the database. A. Database B. Database Application C. Database System D. DBMS E. None of the above 4. DDL allows A. Users to define a database B. Users to delete data C. Users to insert data in a database D. Users to update data from a database E. None of the above 5. Dependency based on only part of a composite primary key is called A. B. C. D. E. Functional dependency. Partial dependency. Transitive dependency. Primary key dependency. Foreign key dependency. Page 1 of 11 BASIC COMPUTER APPLICATION – CSE 1021 6. In a relation schema, the degree of a relation defined as the number of A. Tuples. B. Attributes. C. Data types. D. Relationships. E. Tables. 7. Which of the following acts as the bridge between Human and Machine in a DBMS Environment? A. People B. Hardware C. Software D. Procedures E. None of the above 8. Internal view of the database architecture is the A. Users’ view of the database B. Community view of the database. C. Physical representation of the database on the computer D. Logical representation of the database on the computer E. All of the above 9. Which of the following is an advantage of the client-server architecture? A. Reduced network traffic B. Hardware cost may be reduced C. Increased consistency D. Increased performance E. All of the above 10. One of the benefits of normalisation is that it A. B. C. D. E. Increase the number of attributes Increases data redundancy Increases update anomalies Increases the stability of the relational data model Increases the application maintenance cost 11. Which of the following is TRUE for an Entity Relational Diagram (ERD)? A. B. C. D. E. Represents data view of a system Provides a high level, conceptual view of the database structure Specify the data to be stored Shows the relationship that exists between data items All of the above Page 2 of 11 BASIC COMPUTER APPLICATION – CSE 1021 12. Which of the following is NOT part of an Entity Relationship Diagram (ERD)? A. Entity B. Relationship C. Actor D. Attributes E. Cardinality 13. The different kinds of requirements include: A. B. C. D. E. Functional, non-functional, semi-functional and data requirements. Functional, non-functional, semi-functional and physical requirements. Functional, non-functional, semi-functional and social requirements. Functional, non-functional, semi-functional and organisational requirements. Data, physical, social and organisational requirements. 14. Which of the following is NOT an aim of the requirement analysis phase? A. B. C. D. E. Understand the users. Understand the task. Understand the context. Produce a stable set of requirements. Design questionnaires to elicit specific information 15. Which of the following statements is TRUE? A. B. C. D. People’s immediate memory capacity is very limited Context is not important in affecting our memory Interacting with technology is not cognitive During design implications for attention, we should focus on cluttering the interface E. None of the above 16. Which of the following is NOT a method of externalizing to reduce memory load? A. Notes B. Diaries C. Reminders D. Calendars E. None of the above 17. Which of the following is NOT a valid method of doing annotation? A. Crossing off B. Ticking C. Underlining D. Learning E. None of the above Page 3 of 11 BASIC COMPUTER APPLICATION – CSE 1021 18. â€Å"A department hires many employees. An employee is employed by one department. â€Å" Which cardinality mapping best describes the relationship between Department and Employee? A. 1 to 1 B. 1 to N C. M to N D. N to M E. M to M 19. Which of the following statements is FALSE about data gathering techniques? A. Questionnaires are good for answering specific questions from a large, dispersed group of people. B. Interviews can be structured, unstructured or semi-structured. C. Naturalistic observation is good for exploring issues. D. Workshops are good at gaining a consensus view and/or highlighting areas of conflict. E. Documents are good for understanding legislation, and getting background information. 20. How many columns will be displayed after executing the query : SELECT id, name, surname FROM student; A. 1 B. 2 C. 3 D. 4 E. 0 21. A _____________ can be further subdivided to yield additional attributes. A. Simple attribute B. Composite attribute C. Derived attribute D. Multivalued attribute E. None of the above Page 4 of 11 BASIC COMPUTER APPLICATION – CSE 1021 22. One of the advantages of Supply Chain Management systems is that: A. It allows business to keep inventories at their lowest cost B. It allows businesses to choose the best customers C. It is better than Customer Relationship management systems D. It allows the customer to stay in close contact with its business partners E. All of the Above 23. Which of the following would correctly define computational offloading? A. When a tool is used in conjunction with an external representation to carry out a calculation (e. g. pen and paper) B. To-do lists written to remind us of what to do C. Explaining how we interact with external representations (e. g. aps, notes, diagrams) D. Internal constructions of some aspect of the external world enabling predictions to be made E. None of the above 24. An Enterprise Resource Planning system is a A. System for managing all the resources of the enterprise only B. System used mainly by the HR department C. System with a single database used to link the different business processes of an organisation D. System used only b y senior managers for strategic planning purposes E. System used to carry out day to day activities only 25. If a computer on the network shares resources using the HTTP protocol for thers to use, it is called a A. Browser B. Server C. Client D. Router E. Switch 26. Identify which of the following is INCORRECT about packet switching? A. Data are broken down into datagrams. B. Each datagram has the sender’s IP address and the destination’s IP address. C. All datagrams travel along the same path determined by routers. D. Datagrams are reassembled at destination. E. Loss datagram are retransmitted. Page 5 of 11 BASIC COMPUTER APPLICATION – CSE 1021 27. A URL (Uniform Resource Locator) can be a combination of 1 2 3 4 5 B. 2,3,4,5 C. 1,3,4,5 D. 1,2,4,5 E. 1,2,3,5 28. Which of the following statements is FALSE about the differences between the Internet and the World Wide Web? A. Internet is the interconnection of networks while the WWW is where information is stored B. Internet is physical while WWW is abstract (imaginary) C. Without WWW, Users will not be able to access the Internet D. Cables connect computers together for the Internet while the WWW is connected by hypertext links E. None of the above File Server Router Protocol Path A. 1,2,3,4 29. Which one of the following devices has a sole purpose to extend the physical length of a network? A. Switch B. Repeater C. Bridge D. Router E. Gateway 30. A network protocol is A. Software that facilitates connection to the internet. Page 6 of 11 BASIC COMPUTER APPLICATION – CSE 1021 B. A list of rules that describe how clients and servers communicate. C. Software that allows file copying. D. A gateway calling program for internet bridging . E. None of the above Question 2 [30 marks] (a) Match the following terms to their meaning 1. Data inconsistency A describes what data is stored in the database and the relationships among the data B Conflicting-versions of the same data C Enforces valid relationships between tables in a relational database. D A collection of application programs that perform services for the end-users such as the production of reports E It is a program that interacts with the database at some point in time [5 x 1 mark] [5 marks] 2. Conceptual level 3. Referential integrity. 4. Database Application 5. File Based System (b) (c) List down all the main steps required in designing a database. The following table shows details of vehicle owners in un-normalised form. An owner can have several vehicles. The town of the owner determines the district of the owner. Table : Vehicle_Owner CustSurname Smith Bernes CustForeName Tom Tim District PlaineWilhems Moka Town Curepipe Reduit RegNo X005 Y003 A001 B321 C008 D021 VehicleMake Honda Mitsubishi Nissan Lancer Honda Toyota Spears Britney Black-River Case Noyal Page 7 of 11 BASIC COMPUTER APPLICATION – CSE 1021 (i) Illustrate examples of the following anomalies : 1. Insertion anomalies 2. Update anomalies 3. Delete anomalies [3 marks] (ii) Normalise the data shown in the above table and show the development of your design through 1NF, 2NF and 3NF. Give appropriate names to the relations obtained and underline the primary keys of each relation. Use only the attributes provided in the table. 7 marks] (d) Consider the following scenario : â€Å"The Tertiary Education Authority (TEA) requires a system to hold details of the applicants who apply for programmes run by local institutions. Each programme is run at only one institution, though more than one programme is run at each institution. An applicant may apply for several programmes. Each institution consists of several classes and applicants are allocated to classes after they have been offered a seat. The system will store details such as identity number, surname, forename, address, telephone, date of birth and qualifications of applicants. As for the programme, its code, name and description will be stored. Every class has a name, description, location and type. † Draw the ERD for the above scenario using Chen’s notation. [10 marks] Question 3 [20 marks] (a) Consider the following tables with sample data : Table : Passenger PassID P001 P002 P005 PassName Tom Clavier Smith Polo Tintin Row Address Pamplemousses Souillac RoseMary PhoneNum 78963214 47852369 78965412 Table : Aircraft AirNum AirName Capacity Page 8 of 11 Details BASIC COMPUTER APPLICATION – CSE 1021 MK065 FR785 EM012 Air Mauritius Air France Emirates 150 100 300 TwoWay TwoWay OneWay Table : Flight FlightID F7822 G4522 P9856 PassID P002 P336 P001 AirNum FR633 EM012 MK065 Write the SQL statement which will : (i) (ii) Return the name and address of all passengers. [1 mark] Return all the name of the passengers who has taken the flight which has an ID of MK065. [3 marks] Return all the passenger ID along with the aircraft name whose capacity is 100 on which they have travelled. [4 marks] Return all the aircraft number whose name starts with ‘pa’ and ends with ‘ma’. [2 marks] (iii) (iv) (b) A book is written by an author, published by a publisher and sold by a book store. A reader can read a book. However, for a reader to read a book, he/she must buy the book. The reader can buy the book online or from a bookstore. Draw a use case diagram for this scenario. [6 marks] (c) Conceptual model enables users to readily learn a system and use it effectively. Describe how â€Å"Mental Modelling† is an approach that can help users in understanding a system. [4 marks] Question 4 [20 marks] Page 9 of 11 BASIC COMPUTER APPLICATION – CSE 1021 (a) (i) Differentiate between the two types of information systems which are used at the management level. [6 marks] (ii) Expert system is used at the Knowledge level. Briefly explain the term â€Å"Expert systemâ€Å"? [2 marks] (b) (i) Using appropriate example, describe the format of a URL. [2 marks] (ii) Using the diagram below, describe the processes represented by numbers (1-6) performed by the Domain Name Server. [5 marks] (c) (i) A hub is one of the networking devices that is used in a star topology. Explain the function of a hub. [2 marks] (ii) Consider the network topology below : State ONE advantage and TWO disadvantages of using this topology. Page 10 of 11 [3 marks] BASIC COMPUTER APPLICATION – CSE 1021 END OF QUESTION PAPER Multiple Choice (Circle the correct Answer)