View the step-by-step solution to:

1 Sunset Valley Distributors recently completed a major conversion project. Several months ago, Sunset made the decision to move into the database...

1 Sunset Valley Distributors recently completed a major conversion project. Several months ago, Sunset made the decision to move into the database era. Many of its computer-based files had become unreliable, difficult to maintain, and too inflexible to be used to fulfill many end-user reporting and inquiry requests. A DBMS seemed to be the obvious solution. Two systems analysts were primarily responsible for the conversion project, which took several months to complete. The systems analysts had decided to simply implement each of the computer-based files as a separate table in their relational database. Once the conversion was completed, the same problems that existed with the file-based system reappeared in the database system. Reports contained inaccurate data, report and inquiry requests could not easily be obtained, and data maintenance was still difficult. A consultant was hired to investigate their problems. The consultant acknowledged that many of the problems resulted because the analysts failed to do data modeling.



1.1.1 Using theory and practical examples critically discuss the importance of doing data modeling ahead of time when designing databases

.

1.2 Eudrup University's current student registration system consists of the following ISAM files: STUDENTS, COURSES, INSTRUCTORS, REGISTRATIONS, SPACE, and SCHEDULES. The first three files are fixed-length master files. The last three are variable-length transaction files. The administration would like to integrate all this data into a single database.what are the step-by-step project plan to accomplish this.




2

Pick and Shovel Construction Company is a multistate building constructor specializing in medium-priced town homes. C.T. Scott, the owner, is in your office for the third time today to see how the new relational database project is coming along. Unfortunately, someone mentioned to C.T. that the delay had something to do with achieving normalization.

"Why is all this normalization stuff so important?" he asks. "The old system worked OK most of the time, and now you are telling me that we need all these special rules

.

2.1 Assume that the Pick and Shovel's main entities are its customers, employees, projects, and equipment. A customer can hire the company for more than one project, and employees sometimes work on more than one project at a time. Equipment, however, is assigned only to one project. Draw an ERD showing those entities.


2.2 Add cardinality notation to your ERD

2.3 Create 3NF table designs.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question