ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

Database tasks

•Download as PPTX, PDF•
•
A
Andrew Willetts

The document outlines 3 tasks to practice adding, deleting, and editing records in a database. The first task is to add a new record for the game "Kingdom Hearts" with details including age rating, platform, price, and release date. The second task is to delete the entire record for the game "Tetris" from the database. The third task is to edit the existing record for "Gears of War" by changing the price from £4.99 to £9.99.

1 of 5
Download to read offline
Database tasks
What you need to do ï‚– ï‚™ You need to work through the three tasks on the next 3 slides. ï‚™ When doing the tasks you need to print screen what you are doing into a word document
Task 1  Your first task is to ADD a NEW record to your database, to do this you will need to type this in at the bottom of the table. The details for this are: - Game Name Age Rating Platform Price Release Date Genre Kingdom 3+ Playstation £12.99 15/11/2002 RPG Hearts 2
Task 2 ï‚– ï‚™ Your second task is to DELETE a record from the database, it turns out that a game has been sold and there is no replacement stock, so this needs deleting from the database. You need to find and delete "Tetris", however you cannot just delete each field in the record you need to delete the entire thing.
Task 3   Your third task is to EDIT a record in the database, after looking through your work catalogue during an audit it turns out that one of the entries has an incorrect price and you should be charging more for it. You need to find and change the price of "Gears of War" from £4.99 to £9.99

More Related Content

Database tasks

  • 2. What you need to do ï‚– ï‚™ You need to work through the three tasks on the next 3 slides. ï‚™ When doing the tasks you need to print screen what you are doing into a word document
  • 3. Task 1 ï‚– Your first task is to ADD a NEW record to your database, to do this you will need to type this in at the bottom of the table. The details for this are: - Game Name Age Rating Platform Price Release Date Genre Kingdom 3+ Playstation £12.99 15/11/2002 RPG Hearts 2
  • 4. Task 2 ï‚– ï‚™ Your second task is to DELETE a record from the database, it turns out that a game has been sold and there is no replacement stock, so this needs deleting from the database. You need to find and delete "Tetris", however you cannot just delete each field in the record you need to delete the entire thing.
  • 5. Task 3 ï‚– ï‚™ Your third task is to EDIT a record in the database, after looking through your work catalogue during an audit it turns out that one of the entries has an incorrect price and you should be charging more for it. You need to find and change the price of "Gears of War" from £4.99 to £9.99