Page 490 - Computer_Science_F5

Questions (a) BookID : 1, Title: “Database
1. Describe the steps you took to System Concepts”, Authors: “
create your database and the tables Abraham Silberschatz, Henry
within it. F. Korth, and S. Sudarshan”,
2. How did you handle data PublishedYear: 2020 Chapter Eight: Databases and Database Management Systems
FOR ONLINE READING ONLY
manipulation tasks? Provide (b) BookID : 2, Title : “Artificial
examples of insert, update, and Intelligence in Education:
delete operations you performed. Promise and Implications
3. Explain the queries you used to for Teaching and Learning “,
retrieve specific information. What Authors: “Charles Fadel, Wayne
challenges did you face, and how Holmes and Maya Bialik”,
did you overcome them? PublishedYear : 2017
4. Discuss the performance differences 3. Write a SQL query to retrieve all
you observed before and after columns for all books in the Books
creating indexes on your tables. table that were published after the
Why are indexes important for year 2018.
query optimization? 4. The publication year of “2017” by
5. Reflect on how understanding Charles Fadel, Wayne Holmes, and
database operations and SQL Maya Bialik was mistakenly entered
can be beneficial in real-world as 2017. It was published in 2019.
applications. Write an SQL query to correct this
mistake in the Books table.

Exercise 8.5 5. Assuming there was a mistake,
and the book with BookID 2 is not
1. Create an SQL statement to create supposed to be in the Books table.
a table named “Books”. The table Write an SQL query to delete this
should have four columns: book from the table.
(a) BookID - as an integer and the
primary key,
(b) Title - as a variable character Parallel and distributed Database
with a maximum length of 250 management systems
characters, The concepts of parallel and distributed
(c) AuthorName - as a variable database management systems (DBMS)
character with a maximum lie in how databases can be optimised for
length of 100 characters, and performance, reliability, and scalability.
(d) PublishedYear - as an integer. Given the complexity of these topics
here we are simplifying them including
2. Write an SQL query to insert the providing relatable examples when
following data into the Books table:
possible.

481
Student’s Book Form Five

Computer Science Form 5.indd 481 23/07/2024 12:35