Database Systems

1. Produce a complete Logical Entity-Relationship Diagram for Futurity. This needs to include all the correct tables, relationships, multiplicity constraints, attributes, primary keys and foreign keys. This needs to fit on one page of the report. 2. Provide a step-by-step guide explaining how you produced the Futurity logical ERD i.e. how you mapped the Futurity conceptual ERD into a full logical relational schema. To achieve this, write a series of numbered bullet points (e.g. [1], [2], [3], etc.) to explain how you applied the 10 rules of the Logical Data Modelling Methodology (see Lecture 04), and in which order, to convert the given Conceptual ERD into a Logical ERD. This needs to fit on no more than two or three pages of the report. 3. Write some SQL code to create the Company and the Employee tables in the MySQL RDBMS and insert 4 records in the Company table. 4. Create a PHP file EITHER called [login to view URL] OR [login to view URL] to display a Web-based form to allow an administrator to enter the details of new employee in the Employee table in the MySQL RDBMS. 5. Create a PHP file called [login to view URL] to display a Web-based confirmation page displaying the added customer as for the instructions below. Contact me for more details if your interested.