[go: up one dir, main page]
Scribd
Upload
65 views2 pages

Practical Work 4

The document outlines practical work activities for a computer science course, specifically focusing on database models including hierarchical and network models. It includes sample data for a banking database and a series of true/false questions related to database concepts. The activities aim to enhance understanding of different database structures and their characteristics.

Uploaded by

plutoagcorp
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
65 views2 pages

Practical Work 4

The document outlines practical work activities for a computer science course, specifically focusing on database models including hierarchical and network models. It includes sample data for a banking database and a series of true/false questions related to database concepts. The activities aim to enhance understanding of different database structures and their characteristics.

Uploaded by

plutoagcorp
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Department of Computer Science

CSI244
Practical Work 4

Activity 1:
Illustrate the hierarchical database model using the data in table 1.

Firstname Surname House Street Location/Ward City Account Balance(P)


number Name number
Moemedi Babuile 345 Phokojwe Maruapula Gaborone A-100 200
Avenue
Ernest Mabote Room 23 Mabotho UB Las Vegas Gaborone A-101 500
Road Hostels
Ernest Mabote Room 23 Mabotho UB Las Vegas Gaborone A-108 200
Road Hostels
Gabriel Thebe 4175 Nyerere Broadhurst Gaborone A-121 50
Drive

Table 1: Sample data for banking database

Activity 2:
Using data in Table 1 produce a network model of the database.

Activity 3:

1. A(n) _____ is a relatively simple representation of more complex real-world data


structures.
2. Today, most relational database products can be classified as object/relational.
a. True
b. False

3. The network model has structural level dependence.


a. True
b. False

4. The external model is the representation of the database as “seen” by the DBMS.
a. True
b. False

5. The hierarchical model is software-independent.


a. True
b. False
6. The relational model is hardware-dependent and software-independent.
a. True
b. False

7. A(n) _____’s main function is to help one understand the complexities of the real-
world environment.
a. node b. entity
c. model d. database

8. A(n) _____ is anything about which data are to be collected and stored.
a. attribute b. entity
c. relationship d. constraint

9. A(n) _____ represents a particular type of object in the real world.


a. attribute b. entity
c. relationship d. node

10. In the _____ model, the basic logical structure is represented as an upside-down tree.
a. hierarchical b. network
c. relational d. entity relationship

11. In the _____ model, each parent can have many children, but each child has only one
parent.
a. hierarchical b. network
c. relational d. entity relationship

12. The hierarchical data model was developed in the _____.


a. 1960s b. 1970s
c. 1980s d. 1990s

13. In the _____ model, the user perceives the database as a collection of records in 1:M
relationships, where each record can have more than one parent.
a. hierarchical b. network
c. object-oriented d. entity relationship

14. The object-oriented data model was developed in the _____.


a. 1960s b. 1970s
c. 1980s d. 1990s

15. The _____ data model uses the concept of inheritance.


a. relational b. network
c. object-oriented d. entity relationship

You might also like