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.
Hello I am Software Engineer and expert in database design and development so you can consider me for this Project
Thanks I will wait for your quick Response
I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design.
Here is few technologies I have mastered since last 9 years and can deliver the best solutions if you get me hired.
1) Sql Server 2005/2008/2012
2) MYSQL, MS Access
3) Oracle (PL/SQL)
4) SSIS, SSRS , SSAS and Power BI
5) Data analytics using R-Programming and SAS