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.
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
- Hello! I need help with a question. Even point form would be really helpful. Thank you so much. What are the two most important actions of a responsible
- Pt 1. Economists usually maintain that policy designed to increase aggregate demand cannot have any long-run real effects. What lies behind this argument?
- I need to provide an example or two showing how rules describing small but cumulatively significant outcomes often fail to control our behavior.