Closed

DBMS Tutorial needed - Excellent English Needed

This project received 11 bids from talented freelancers with an average bid price of $7 USD / hour.

Get free quotes for a project like this
Employer working
Project Budget
$2 - $8 USD / hour
Total Bids
11
Project Description

Here is the outline: Complete tutorial ideally 3000-4000 words. Need it done within a day or two max. Extremely high quality English needed. No compromise here. No companies!

The articles should cover following topics in the natural easy to read flow:

• Article 1

• What is DBMS, history of DBMS

• What are the approaches to DBMSs (relational, object oriented, etc)

• Who are the various users of databases?

• What are the advantages of database systems over flat file systems?

• What are the three levels in a database architecture?

• Article 2

• Examples of RDBMs MySQL, Oracle, MS SQL (a little history)

• What is a domain? How is it used for referential integrity?

• What is a primary key? Superkey? Candidate key? foreign key?

• Relation, attribute, tuple definitions in the relational schema.

• Relational Algebra -- be able to construct queries; syntax will be provided

• What is a natural join?

• Entity-relationship modeling -- be able to diagram a simple database with entities, relationships, attributes and ISA hierarchies

• Transformation of ER to Relational schema

• What are functional dependencies? How are they determined? --be able to enumerate all non-trival FDs in a relation.

• Article 3

• What are the basic normal forms?

• 1NF, 2NF, 3NF and BCNF decomposition--why and how.

• SLI and CLI approaches to embedded SQL

• B+ tree insertion and growth operations

• Article 4

• Introduction to NOSQL approach (history, facts), Explanation of eventually consistent trade off

• NoSQL Database Types

• Overview of Hadoop, Mongo DB or Raven DB

• Dynamic Schemas advantage

• Auto-sharding

• Article 5

• DynamoDB: Amazon's Highly Available Key-value Store

• NoSQL Data in Windows Azure

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online