Reverse engineer

  • Posted:
  • Proposals: 0
  • Remote
  • #39045
  • Archived
  • 0

Description

Experience Level: Intermediate
Part 1


I need to Reverse engineer the underlying relational database schema, this should be done by means of picking out various data attributes, organising those attributes into tables, and then normalising the tables.
Note: focus on constructing part of the overall schema rather than building the complete picture. I just need a few inter-linked data-intensive pages and base the work on just those pages alone. I need a database that has at least six tables when refined to third normal form (3NF)

The work must have a complete list of all the databases tables and their attributes. Must clearly show how you progessed from un-normalised form (ONF) through first (1NF), Second (2NF), and third normal form (3NF), explaining what changes, if any, you made at each stage and what changes you made. If in moving from each stage to the next, no changes were made to a particular table, you must explain why no changes were necessary. Clearly state any assumptions that you make.

For each table, Please specify a primary key. If appropaite. Also specify the foregin key(s) and say what table(s) it/they link to.
A relational database scheme or physical entity-relationship diagram (ERD) show the final model.

Part 2

I need the sql code necessary to create the database tables that you designed in part 1. I also need you to populate these tables with some sample dummy data, and to build a number of sql queries.

The CREATE TABLE statements that are required to build the database. For each table, you must specify field data types and key field(s), as well as required values, UNIQUE values and validation CHECK constraints where applicable. You must also define the relationships between tables, inculding referential integrity rules. (this code can be automatically generated by creating a data model with viso.

Simple Queries (single table)
Multi-table Quries (equi-joins)
Sub-queries
Summary Queries (for example: MIN, MAX, SUM, COUNT, AVG)
Calculated Fields
Grouped Queries
Self-joins
Unions
Action Quires ( for example: INSERT, UPDATE, DELETE)
Views

You should make ample use of the relational operators (<,>, <=> and <>), logical operators (AND, OR, NOT), mathematical operators (*, +, -, /), pattern matching (like), set membership test (IN), and null values test (IS NULL, IS NOT NULL).

Note: I want to learn all about database so it is important to document work in great detail and highlight clearly how you created everything.

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.