Create a Database in SQLite

Design a database for storing information about medical doctors, their patients, and ilnesses: 1. Draw its E-R diagram. 2. Give a relational representation of the E-R diagram that allows for 2 functional preserving and lossless join decompositions. Describe its functional dependencies. 3. Give the two decompositions and prove that they are lossless join and functional preserving. 4. Give the SQL DDLs for creating the three versions of the database. 5. Fill the first database with data (at least 100 rows in each table). 6. Give the SQL queries to copy the data from the first version into its 2 decompositions. 7. Propose in English 3 queries that require at least 2 table joins each and such that all tables are involved in at least 2 queries. 8. Propose SQL implementations of the 3 queries on all three versions of the database. 9. Test the time in ns for executing the 3 queries on each database, by running each of them 1000 times. Submit the databases populated with data, a file for each ddl ([login to view URL], [login to view URL], [login to view URL]), and a report with a separate section for which of the above points.