View the step-by-step solution to:

1 Sunset Valley Distributors recently completed a major conversion project.

Please can some one help me with the following case studies, i tried my best but could not get the right answers.

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. (10)

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. how do i write a step-by-step project plan to accomplish this. (10)


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. (6)

2.2 Add cardinality notation to your ERD (4)

2.3 Create 3NF table designs. (5)


3

Pacific Imports, a wholesale distributor of a wide variety of imported products, is located in

Los Angeles, California. Pacific has just completed the automation of its mail order system.

This mini case reviews the design and implementation.

  • At approximately 8:30 each morning, the Order Entry department receives all new sales

order forms. These forms include orders received both by mail and over the phone. Order

Entry enters and edits all orders on personal computers, creating a batch of orders on a

network file server.

  • The batch of orders is transmitted from the server's disk to an AS/400 midrange computer

via a network gateway over a TCP/IP point-to-point network connection. There, the orderprocessing

program checks the inventory master file (actually, a database table) to validate

products ordered and to determine the availability and price of the products ordered. For

any products that are out of stock, a backorder is created in the database and printed as a

notice for the customer. Fillable orders (and partial order) are then processed as follows.

  • Another program checks the customer accounts master file to check credit. For customers

who have a poor credit rating, a prepayment request is printed. The order is placed on

hold in the order master file. Also, a report of these notices is prepared for management.

The program prints an order confirmation letter for those orders that will be filled.

  • Another program produces a four-part warehouse order form that includes a picking copy,

a packing copy, a shipping copy, and an invoicing copy. The processed order is moved to a

sales master file, a copy of which is archives on magnetic tape for backup and later use.

The system also includes an on-line program that allows the sales manage both to query

the inventory master file to obtain prices and to query the customer accounts master file

to obtain credit information needed to manually override a credit rejection. This program

is available to the sales manager from 8am until noon each working day.

  • Customer order cancellations are processed immediately upon receipt (by mail or phone).

When the request is received by a clerk, he or she enters the order cancellation using the

PC as a terminal into the AS/400. An on-line program reads the sales master file to

determine the order's status. If the order has not been filled, the clerk phones the

warehouse to have the order terminated. At the end of the day, the program generates

cancellation notices for customers and a cancellation report for the sales manager.

3.1 What are the limitations of the English language for describing a design to

programmers who must implement that design? (10)

3.2 Did you spot any errors of omission in the narrative description - that is, important

questions or processes that were not covered? (5)

3.3 Draw a physical data flow diagram for this case. (5)

3.4 Draw a system flowchart for this case. (5)


4

PC Training registrar maintains data about the following entities: (a)courses, including number, title, credits, syllabus, and prerequisites; (b) course offerings, including course number, year, semester, section number, instructor(s),timings, and classroom; (c) students, including student-id, name, and program; and (d) instructors, including identi_cation number, name, department, and title. Further, the enrolment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modelled.

4.1 Construct an E-R diagram for the registrar's of_ PC Training. Document all assumptions that you make about the mapping constraints. (10)


5

Sand and Surf Retailers recently acquired several smaller companies to expand its chain of clothing outlets. To establish consistency for the current organization and future acquisitions, Sand and Surf decided to develop an in-house application called SPS (Standard Purchasing System). The SPS system would standardize purchasing practices for each Sand and Surf subsidiary and manage all purchasing information. System testing will be completed by the end of the week.

5.1 Using the theory and practical examples describe the four types of documentation. (12)

5.2 What type(s) of documentation would you recommend for this application and why?(4)

5.3 During application development, what steps should the IT staff follow to develop a structure chart? (4)

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