I need help taking information from a database book, Concepts of Database Management 7th Edition, specifically from Appendix A, and changing key aspects of the database to reflect these changes. For example I might need to change the database design so that each department of a school needs to change it’s database to allow only one type of major to be offered from each department. There are 4 specfic changes that need to be incorporated and that includes going through the normiliztion process 1-4, and declaring all dependencies throughout the procees, as weel as creating an ER diagram of each change made. Bellow is the assaignment and attached should be a PDF of the appendix A with the information and examples.

Database Assignment

Appendix A Marvel College Example:

Study the descriptions and discussions in Appendix A of this case study. The questions that need to be submitted for this assignment are similar to the ones in Appendix A.

Use the information and design of the Marvel College database as discussed in Appendix A of the PDF and use that information to discuss the impact the following changes have on the design for the Marvel College database.  Assume all changes are independent of each other so you do not have to carry changes from one question to the next question.

For ALL problems, go through the process of normalizing any resulting tables and then show them in DBDL (new or changed tables).  Also update the final cumulative design (Figure A-17) with the new structure and dependencies.  Include ALL tables from the Database in the ER diagram for each question (simple boxes as we did in the last two chapter 6 assignments.  Put the changed tables in a different box / connecting line color.

Follow the rubric bellow to adjust the database to fit the following conditions:

1. More than one instructor might teach a given section of a course, and each instructor must be listed on the time schedule

2. Each Department offers only a single major

3.  On the registration request form, a student may designate any number of alternates along with his or her primary choice.  These alternates are listed in priority order, with the first one being the most desired and the last one being the least desired.

4. The College wants to expand the database to cover the different dates and times for final exams.  There will be several groups/blocks for each semester identified by a TestGroupID that sections will be assigned to.  Each TestGroup will be assigned a Date and Time for the final exams.   All sections assigned to a specific TestGroupID will have the exam on the same Date and Time.


Question 1:

Q1 – New Tables / Fields Listed + Basic description on change to database you will be making

Q1 – 1NF + Dependencies

Q1 – 2-3NF Conversion + Final Table(s) DBDL

Q1 – ER Diagram

Question 2:

Q2 – New Tables / Fields Listed – New Tables / Fields Listed + Basic description on change to database you will be making

Q2 – 1NF + Dependencies

Q2 – 2-3NF Conversion + Final Table(s) DBDL

Q2 – ER Diagram

Question 3:

Q3 – New Tables / Fields Listed – New Tables / Fields Listed + Basic description on change to database you will be making

Q3 – 1NF + Dependencies

Q3 – 2-3NF Conversion + Final Table(s) DBDL

Q3 – ER Diagram

Question 4:

Q4 – New Tables / Fields Listed – New Tables / Fields Listed + Basic description on change to database you will be making

Q4 – 1NF + Dependencies

Q4 – 2-3NF Conversion + Final Table(s) DBDL

Q4 – ER Diagram

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages

Order your paper today and save 7% with the discount code HOME7