Færdiggjort

PROJECT and SQL queries about company preparing toys for children

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.

Evner: Database Administration, Ingeniørarbejde, SQL

Se mere: michael widenius, database management systems (3rd edition) by raghu ramakrishnan and johannes gehrke pdf, database management system by raghu ramakrishnan 2nd edition pdf, mysql, database management system raghu ramakrishnan 4th edition pdf, database management systems 3rd edition even solutions, database management systems, ramakrishnan, and gehrke, 3rd edition, 2014, mcgraw hill pdf, raghuram krishnan dbms 3rd edition pdf, project online shipping company based html, streamlining sql queries, telephone bill generation project sql, vbnet database project sql server, project need unique company name, invoice billing project sql database design document, project time marketing company, table sql queries join, example php project sql, access project sql server, free project report telephone company, project sql server

Om arbejdsgiveren:
( 0 bedømmelser )

Projekt ID: #19673417

Tildelt til:

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 på 1 dag
(15 bedømmelser)
3.3

4 freelancere byder i gennemsnit $43 på dette job

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 Flere

$25 USD på 1 dag
(15 bedømmelser)
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 Flere

$100 USD in 2 dage
(4 bedømmelser)
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 Flere

$25 USD på 1 dag
(1 bedømmelse)
1.4