1 / 14

Databases.

Databases. Revision tip: Focus on the things you find difficult first. “Every lesson counts – don’t waste a minute.”. Importance of databases. Give a definition of a database. (2 marks) ……………………………………………………............................................

elkan
Download Presentation

Databases.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Databases. Revision tip: Focus on the things you find difficult first.

  2. “Every lesson counts – don’t waste a minute.”

  3. Importance of databases. • Give a definition of a database. • (2 marks) • ……………………………………………………............................................ • .................................................................................................................... • ……………………………………………………............................................ • ...................................................................................................................... • ……………………………………………………............................................ • ...................................................................................................................... • ……………………………………………………............................................ • ...................................................................................................................... • ……………………………………………………............................................ • ...................................................................................................................... • Most organisations depend on their databases in order to operate. Because of this databases need to be:(4 marks) • i) ……………………………………………………............................................ • ........................................................................................................................ • ii) ……………………………………………………............................................ • ........................................................................................................................ • iii) ……………………………………………………............................................ • ........................................................................................................................ • iv) ……………………………………………………............................................ • ........................................................................................................................

  4. Exam tip:Remember that validation can be set up in any way that the database designer wants. Data security & data integrity Explain the term ‘verification’. (2 marks) ……………………………………………………............................................ .................................................................................................................... ……………………………………………………............................................ ...................................................................................................................... ……………………………………………………............................................ ……………………………………………………............................................ ...................................................................................................................... What is a ‘check digit’. (2 marks) ……………………………………………………............................................ .................................................................................................................... ……………………………………………………............................................ ...................................................................................................................... ……………………………………………………............................................ ..................................................................................................................... ……………………………………………………............................................ Explain the term ‘validation’. (3 marks) ……………………………………………………............................................ .................................................................................................................... ……………………………………………………............................................ ...................................................................................................................... ……………………………………………………............................................ ...................................................................................................................... ……………………………………………………............................................ ...................................................................................................................... ……………………………………………………............................................ ...................................................................................................................... A data table is set up to hold personal details of customers for an online business. Describe how the following fields would be validated: (8 marks) (a) Surname ……………………………………………………............................................ .................................................................................................................... (b) Date of birth ……………………………………………………............................................ .................................................................................................................... (c) Gender ……………………………………………………............................................ .................................................................................................................... (d) Credit limit ……………………………………………………............................................ .................................................................................................................... What is meant by a range check? (2 marks) ……………………………………………………............................................ .................................................................................................................... ……………………………………………………............................................ ...................................................................................................................... ……………………………………………………............................................ ...................................................................................................................... ……………………………………………………............................................

  5. Data redundancy Flat file vs. Relational What is a flat file database? (1 mark) ……………………………………………………............................................ .................................................................................................................... ……………………………………………………............................................ ...................................................................................................................... 6. Here is part of a database of customer details: Explain what a relational database is. (3 marks) ……………………………………………………............................................ .................................................................................................................... ……………………………………………………............................................ ...................................................................................................................... ……………………………………………………............................................ ..................................................................................................................... ……………………………………………………............................................ ..................................................................................................................... ……………………………………………………............................................ (a) Define the term data redundancy.(1 mark) ……………………………………………………............................................ .................................................................................................................... ……………………………………………………............................................ (b) Explain how data redundancy affects this table.(2 marks) ……………………………………………………............................................ .................................................................................................................... ……………………………………………………............................................ ...................................................................................................................... Explain what problems might occur as a result of the redundancy in this example.(2 marks) ……………………………………………………............................................ .................................................................................................................... ……………………………………………………............................................ ...................................................................................................................... (d) Explain how the data could be stored to eliminate this problem.(2 marks) ……………………………………………………............................................ .................................................................................................................... ……………………………………………………............................................ ......................................................................................................................

  6. Database Management System (DBMS) • Describe four features of a typical DBMS. • (4 marks) • i) ……………………………………………………............................................ • ........................................................................................................................ • ii) ……………………………………………………............................................ • ........................................................................................................................ • iii) ……………………………………………………............................................ • ........................................................................................................................ • iv) ……………………………………………………............................................ • ........................................................................................................................ Give the data that would result from running the following queries on the table below: (8 marks) (a) SELECT Surname, City WHERE Sex = “m” ……………………………………………………............................................ .................................................................................................................... (b) SELECT Surname, City WHERE Sex = “m” AND Years in employment > 3 ……………………………………………………............................................ .................................................................................................................... (c) SELECT Surname, Salary WHERE Years in employment < 4 AND Salary > 35000 ……………………………………………………............................................ .................................................................................................................... (d) SELECT Surname WHERE City = “Birmingham” OR Years in employment = 4 ……………………………………………………............................................ .................................................................................................................... Construct a query that would produce the following result: (a) A list of surnames and salaries of all female employees who live in Birmingham. (2 marks) ……………………………………………………............................................ .................................................................................................................... ……………………………………………………............................................ Explain the difference between an entity and a table. (2 marks) ……………………………………………………............................................ ..................................................................................................................... ……………………………………………………............................................ ..................................................................................................................... ……………………………………………………............................................ ……………………………………………………............................................ ……………………………………………………............................................ ……………………………………………………............................................ Describe two ways in which a query can be constructed. (2 marks) ……………………………………………………............................................ ..................................................................................................................... ……………………………………………………............................................ ..................................................................................................................... ……………………………………………………............................................ ……………………………………………………............................................ ……………………………………………………............................................ ……………………………………………………............................................

  7. Past paper exam questions. 2011 past paper.

  8. Past paper answers. 2011 past paper. Notes: What do I need to improve?

  9. Past paper exam questions. 2011 past paper.

  10. Past paper answers. 2011 past paper. Notes: What do I need to improve?

  11. Past paper exam questions. 2012 past paper. Long answer question. @CES_teach

  12. Past paper answers. 2012 past paper. Notes: What do I need to improve?

  13. Past paper exam questions. 2013 past paper.

  14. Past paper answers. 2013 past paper. Notes: What do I need to improve?

More Related