EXAMSHARE

Western Delta University, Oghara Delta State

department of computer science
college of computing
western delta university

first semester examination 2023/2024 session

CSC311 - database design and management time: 2hrs

Answer any four (4) questions

  1. Question 1

    1. Highlight three (3) components of a DBMS environment. (6 marks)
    2. What is the major objective of the three-tier architecture used in a DBMS? (2.5 marks)
    3. With the aid of a diagram, describe the different levels of Data Mapping in DBMS? (6 marks)
    4. Differentiate between the Hierarchical and Network Data Model. (3 marks)

  2. Question 2

    1. Write a short note on the concept of the Relational Data Model. (2.5 marks)
    2. State the criteria that must be fulfilled at each of the stages of First, Second, and Third Normal Forms. (6 marks)
    3. What is the purpose of Normalization? (4 marks)
    4. Match the items in Column A to their definitions in Column B.
      Column AColumn B
      Data maintenanceA. It refers to how well the data in the database is protected from crashes, hacks and accidental deletion.
      Data integrityB. It refers to how accurate and consistent the data in a database is.
      Data redundancyC. It refers to the separation between data and the application (or applications) in which it is being used.
      Data securityD. It refers to monthly, daily or hourly tasks that are run to fix errors within a database and prevent anomalies from occuring.
      Data independenceE. It refers to storing the exact same data at different places in a database.
      (5 marks)

  3. Question 3

    1. Briefly explain the following terms.
      1. Update Anomaly
      2. Deletion Anomaly
      3. Insertion Anomaly
      (6 marks)
    2. What is Data Independence? (2.5 marks)
    3. Normalize the following table into First, Second, Third, and Fourth Normal Forms:
      Cust_NameShipping AddNewsletterSupplierSupplier_NumberPrice ($)
      Alan SmithXbox One35 Palm St, MiamiXbox NewsMicrosoft(800) BUY-XBOX250
      Roger BanksPlaystation 547 Campus Rd, BostonPlaystation NewsSony(800) BUY-SONY300
      Evan WilsonPlaystation 528 Rock Av, DenverXbox News, Playstation NewsWholesaleTOLLFREE450
      Alan SmithPlaystation 548 Campus Rd, BostonPlaystation NewsSony(800) BUY-SONY300
      (2.5 marks)

  4. Question 4

    1. Write short notes on the following terms:
      1. Physical Data Independence
      2. Composite Key
      3. External/Conceptual Mapping
      (6 marks)
    2. State one major drawback as it concerns Normalization. (2 marks)
    3. With the aid of a diagram, describe the traditional-based file system. (4 marks)
    4. One key drawback of the Traditional File-Based System is Concurrency control. Briefly describe what is meant by this term. (3 marks)
    5. Differentiate between a Database Designer and Database Developer. (2.5 marks)

  5. Question 5

    1. State three (3) ways in which a functional database can contribute to the successful running of an organization.(3 marks)
    2. State a practical example on how data redundancy can be controlled in a database as opposed to file processing. (2.5 marks)
    3. State one objective of the principle of relational database. (3 marks)
    4. Briefly describe the Internal level of a database schema, listing its attributes/characteristics. (5 marks)
    5. State the difference between DML and DDL facilities provided in a database management system. (4 marks)

  6. Question 6

    Cust_IDCustomer_NameItemShipping_AddressPrice
    1001Nnamdi OkekeXbox OneLagos100,000
    1002Joy ObusPlaystation 4Benin150,000
    1003Raymond WilliamsPS VitaWarri70,000
    1004Andrew AdeoluMac LaptopAbuja200,000
    1005Mary SlessorTelevisionPort Harcourt80,000
    1006Jane OkparaRechargable FanBenin20,000
    1007Chris AmoduPower BankAbuja10,000
    1. The relation above, CUSTOMERS, contains data about the sales of items from an outline shop and all monetary value is in Naira. Use it to answer the questions below:
      1. Write an SQL statement to view all the data available in the relation. (2 marks)
      2. Write an SQL statement that queries only the customers that residing in Benin. (2.5 marks)
      3. Write an SQL statement to query the customers who have purchased goods worth N70,000 and above. (3 marks)
      4. Write an SQL statement to update the data about Raymond Williams who is a repeat customer and has moved from Warri to Jos. (2 marks)
      5. Write an SQL statement to delete from the table all information about the customer "Joy Obus". (2 marks)
    2. Within the concept of a Database, define a View. (3 marks)
    3. List three (3) examples of database usage in your environment. (3 marks)