Please can some one help me with the following case studies, i tried my best but could not get the right answers.
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)
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
2.2 Add cardinality notation to your ERD (4)
2.3 Create 3NF table designs. (5)
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)
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)
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)