
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:
- a list of all the apps that have been installed on the device (only the name of the app).
- a list of all the apps which require 2 Mb of disk space.
- name and amount of RAM required for all the apps which occupy 5 Mb of disk space.
- the amount of memory required by the app called "Facebook".
- the id of the app "Facebook".