Normalizing the Relational Model and Creating a Normalized SQL Database Worksheet

Description

Task 1:

Begin with the list of the tables that the entities and relationships from the E-R diagram mapped to naturally. The ER Diagram is attached as a file. For each table on the list, identify the functional dependencies. List the functional dependencies in a Microsoft Word document.

Task 2:

Normalize the relations to BCNF, placing the normalized relations in your Word document.

Task 3:

Then decide whether the resulting tables should be implemented in that form. If not, explain why in your Word document.

Task 4:

For each table, write the table name and write out the names, data types, and sizes of all the data items, Identify any constraints, using the conventions of the DBMS you will use for implementation. Add this information to your Word document.

Task 5:

Write and execute SQL statements to create all the tables needed to implement the design. Note that you will need to name your database something different then the name you previously used.

Task 6:

Insert about five records in each table, preserving all constraints. Put in enough data to demonstrate how the database will function.

Task 7:

Write SQL statements that will process five non-routine requests for information from the database just created. For each, write the request in English, followed by the corresponding SQL command. At least one of these should reference a newly normalized table.

Task 8:

Create at least one new trigger and write the code for it.

Deliverable:

You will be submitting one (1) Word Document (docx) and sql script files for Tasks 7-8. Please do not zip the files together, submit them as individual files!

Normalizing the Relational Model and Creating a Normalized SQL Database Worksheet

Tips in writing a perfect essay

Writing a perfect essay requires careful planning, research, and attention to detail. Here are some tips to help you craft a great essay:

Normalizing the Relational Model and Creating a Normalized SQL Database Worksheet

ORDER NOW AND GET A PLAGIARISM FREE QUALITY PAPER

  1. Start with a clear thesis statement that states your main argument.
  2. Use evidence and examples to support your thesis statement.
  3. Create an outline to organize your thoughts and ensure a logical flow of ideas.
  4. Use clear and concise language, avoiding unnecessary jargon or complex sentence structures.
  5. Edit and proofread your essay carefully for grammar, spelling, and punctuation errors.
  6. Take breaks and come back to your essay with fresh eyes to ensure you haven’t overlooked anything.

By following these tips, you can write a well-structured, well-researched, and compelling essay.

Normalizing the Relational Model and Creating a Normalized SQL Database Worksheet

  

“ OVER THE TIME WE’VE HAD A HIGH SUCCESS RATE ON THIS ASSIGNMENT. CLICK HERE AND GET A PLAGIARISM FREE PAPER”