For this assignment you will work individually to design and test a simple but specific database.
computer science
Description
For this assignment you will work individually to design and test a simple but specific database. You will carry out the ERIEER design, derive the Relational Model schema, translate the schema into a MySQL database, populate the database with some sample data, and write the required number of SQL queries. You will also have to provide some short motivation for your specific design. The goal of this test is to demonstrate that you have the knowledge of designing a simple database for a real-world problem.
Database description
Social networks as Facebook use profiles to store ¡n formation about their users. Create a simple database to store these user’s profiles. A user has a nickname (unique), a password, a real name and a valid email account. Users can write comments, which are composed by a text and the publication date. Furthermore, users ca in photos. A Photo has a filename and an optional description. To tag users ¡n the photos, s used. The coordinates of these frames are stored in the photo too in order to know whig appear ¡n each photo. Also, other users can add comments to a photo and you need to store these comments too.
