This case study describes a company called StayHome, which rents out videos to its members. The first branch of StayHome was established in 1982 in Seattle but the company has now grown and has many branches throughout the United States. The company’s success is due to the first class service it provides to its members and the wide and varied stock of videos available for rent. As StayHome has grown, so has the difficulties in managing the increasing amount of data used and generated by the company. To ensure the continued success of the company, the Director of StayHome has urgently requested that a database application be built to help solve the increasing problems of data management. Below is a description of a Branch view of the company. Branch View of StayHome The users’ requirements specification for the Branch view is listed in two sections: • the • the section describes the data used by the Branch view; section provides examples of how the data is used by the Branch view (that is, the transactions that staff have to perform on the data). Data Requirements The data held on a branch of StayHome is the branch address made up of street, city, state, and zip code, and the telephone numbers (maximum of 3 lines). Each branch is given a branch number, which is unique throughout the company. Each branch of StayHome has staff, which includes a Manager, one or more Supervisors, and a number of other staff. The Manager is responsible for the day-to-day running of a given branch. Each branch has several Supervisors and each Supervisor is responsible for supervising a group of staff. The data held on a member of staff is his or her name, position, and salary. Each member of staff is given a staff number, which is unique throughout the company.

This case study describes a company called StayHome , which rents out videos to its members. The first branch of StayHome was established in 1982 in Seattle but the company has now grown and has many...

This case study describes a company called
StayHome, which rents out videos to its members. The
first branch of
StayHome
was established in 1982 in Seattle but the company has now grown and has
many branches throughout the United States. The company’s success is due to the first class service it
provides to its members and the wide and varied stock of videos available for rent. As
StayHome
has
grown, so has the difficulties in managing the increasing amount of data used and generated by the
company. To ensure the continued success of the company, the Director of
StayHome
has urgently
requested
that
a
database
application
be
built
to
help
solve
the
increasing
problems
of
data
management.
Below
is
a description
of
a Branch view
of
the company.

Branch
View
of
StayHome

The
users’
requirements
specification
for
the
Branch
view
is
listed
in
two
sections:

•

the

section
describes
the
data
used
by
the
Branch
view;

section
provides
examples
of
how
the
data
is
used
by
the
Branch
view
(that

is,
the
transactions
that
staff
have
to
perform
on
the
data).

Data
Requirements

The data held on a branch of StayHome is the
branch address
made up of
street, city, state, and zip
code, and the telephone numbers (maximum of 3 lines). Each branch is given a
branch number, which
is
unique
throughout the company.

Each branch of StayHome has
staff, which includes
a Manager, one or more Supervisors, and a
number of other staff.
The Manager is responsible for the day-to-day running of a given branch.
Each
branch has several Supervisors and each
Supervisor is responsible for supervising a group of
staff.

The data held on
a member of staff
is his or her
name, position, and salary. Each member of staff is
given

a staff
number,
which is
unique throughout
the company.

Oct 04, 2022

SOLUTION.PDF

This case study describes a company called StayHome , which rents out videos to its members. The first branch of StayHome was established in 1982 in Seattle but the company has now grown and has many...

Branch
View
of
StayHome

Data
Requirements

Get Answer To This Question

Related Questions & Answers

Submit New Assignment

This case study describes a company called StayHome , which rents out videos to its members. The first branch of StayHome was established in 1982 in Seattle but the company has now grown and has many...

BranchViewofStayHome

DataRequirements

Get Answer To This Question

Related Questions & Answers

Submit New Assignment

Branch
View
of
StayHome

Data
Requirements