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.
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.