PROJECT and SQL queries about company preparing toys for children

Suoritettu Julkaistu 4 vuotta sitten Maksettu toimituksen yhteydessä
Suoritettu Maksettu toimituksen yhteydessä

PROJECT GUIDE and SQL queries about company preparing toys for children

a company preparing toys for children You can write project report in any editor. You will send in PDF format. Send your report and your database backup file to and "' deadline in 22 may "'

Your projects will be graded in the following form example :

1. (10 pts) General document readability: a. Cover page including project subject, names & student ids of group members, b. Table of contents, c. Abbreviations page, d. Hyperlink from table of contents to pages for all heading levels, e. Prevent grammar errors, f. Prevent typos

2. (10 pts) Introduction: a. Give brief information about your company including mission and vision. b. Define the purpose of your database. Who will use it at what level? (Logical and view levels)

3. (10 pts) Data requirements: List all entity sets, relationship sets, attributes. Define appropriate domains for attributes.

4. (10 pts) ER diagram: Define cardinalities for all relationships, draw the ER diagram. You can use any SW package. If your organization is large, you may use multiple schemas.

5. (10 pts) Database tables: Convert your ER diagram to tables. List your tables with attributes in parenthesis, primary key column(s) underlined and write foreign key constraints by words. For example:

employee (employee-name, city, district, street, door-number) company (company-name, city, district, street, door-number) works (employee-name, company-name, salary) For works table, company-name is a foreign key referencing company table and employee-name is a foreign key referencing employee table.

Alternatively, you may draw a schema diagram showing foreign keys on the diagram.

6. (10 pts) Normalization: Check all your tables for 1NF, 2NF and 3NF, describe how you check at project report. Correct your design if there is a problem with these normalization levels.

7. (20 pts) SQL Queries: Generate your database at PostgreSQL 9.5 and insert some data. Design at least 10 complex and meaningful SQL queries for prospective users. Write these queries to your project report. Take backup of your database and send to me.

8. (20 pts) Presentation: 15 minutes presentation of your project and SQL queries.

Tietokannan hallinto tekniikka SQL

Projektin tunnus: #19673417

Tietoa projektista

4 ehdotusta Etäprojekti Aktiivinen 4 vuotta sitten

Myönnetty käyttäjälle:

AbdulBasitAli045

Hi, Contact Me for Quality Work. relevant skills i have: MS-Visio / DataBasse / SQl Server / ERD / Relationship Thank You and i look forward to the opportunity to work with you.

$20 USD 1 päivässä
(15 Arvostelua)
3.3

4 freelanceria on tarjonnut keskimäärin $43 tähän työhön

hinahanif15

Greetings, I am interested in doing this job. Hopefully we will discuss further details in PM. I am interested in doing this job. Hopefully we will discuss further details in PM.I am interested in doing this job. H Lisää

$25 USD 1 päivässä
(15 arvostelua)
4.0
huseyinaygun

Dear Sir/Madam, I have relational database design and development experience of 10 years. Recently I completed 5 Database Systems Course projects which cover: - Conceptual design (ER Diagram) - Creation of database Lisää

$100 USD 2 päivässä
(4 arvostelua)
2.9
Mickelson

My esteemed employer, I have read carefully at your proposal. I think I am the right person for the project. I have been doing web development for over 12 years. I place my highest priority on credit. If you recommend Lisää

$25 USD 1 päivässä
(1 arvostelu)
1.4