App

Task

You have been asked to create a database for keeping track of all the apps installed on a device; it also must keep track of the amount of disk space each app occupies and of the amount of RAM it requires.

Design an entity-relationship diagram, a relational schema and an instance of the database (which must include the app "Facebook").

Create also the queries which will return:

1. a list of all the apps that have been installed on the device (only the name of the app).
2. a list of all the apps which require 2 Mb of disk space.
3. name and amount of RAM required for all the apps which occupy 5 Mb of disk space.
4. the amount of memory required by the app called "Facebook".
5. the id of the app "Facebook".