Reverse engineer
4960
£50(approx. $63)
- Posted:
- Proposals: 0
- Remote
- #39045
- Archived
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.
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.
Brian M.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
11 May 2024
Ireland
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies