Page 475 - Computer_Science_F5
P. 475
Computer Science Deliverables: 6. What features would you find in
A report summarising your work and
an object-oriented database model
reflections including screenshots for
that are not typically present in a
detailed schema design, Sample data
relational database model?
entries, Implemented database, and
FOR ONLINE READING ONLY
SQL queries or commands used. In
relate to database models? Provide
a report explain the rationale behind 7. How do data structures like trees
an example of a database model
your design choices and benefits and that uses this structure.
limitations of your chosen model.
Document your work in a portifolio.
Database Management Systems
(DBMS)
Exercise 8.4
Database management is the process of
1. Describe the steps you would take organizing, storing, and retrieving data
to convert unnormalised tables to from a computer. It involves designing,
the First Normal Form, Second implementing, and sustaining stored data
Normal Form, and Third Normal
Form. to optimise its value, which database
2. Provide at least one example management represents. In designing
a system, a programmer must have a
relevant to a school or college
environment that illustrates reasons database to store data. For example, if
for converting database tables to you want to store student results in an
the First, Second and Third Normal academic records system, you need to
Forms. have a database so that all the data can
3. Contrast relational and object- be stored in it. A database enables you
oriented models and give two to perform many operations, such as
examples of their uses in real life inserting, updating, and deleting data.
for each of them. Some common database management
4. Why is the relational model the systems include MySQL, PostgreSQL,
most used model today despite the SQLite, Microsoft Access, SQL Server,
continued inventions of even newer FileMaker, Oracle, RDBMS, dBASE,
models? Clipper, and FoxPro.
5. Identify a real-world application
for each of the following database Structured Query Language
models: hierarchical, network, Structured Query Language (SQL)
and relational. Justify your choice is a database programming language
based on the characteristics of each designed to retrieve and manage data in
model. a relational database.
466
for Advanced Secondary Schools
Computer Science Form 5.indd 466 23/07/2024 12:34
