FinalExam docx is what I need assistance with, the others are aid in completing the work.
BCIS 5307 – Final Exam
Saving Instructions: Save the Final Exam Document using the following naming convention: CourseNumber_LastNameFirstInitial-FinalExam (i.e., 5307-SharpJ-FinalExam)
MindPlay Educational Toys is a regional, California based company that currently has stores in Los Angeles, San Francisco, and San Diego. The company produces their own line of educational toys and also sells other toys from other companies in their three stores.
MindPlay’s main customer base consists of parents and children interested in play that encourages learning. MindPlay has also recently created loyalty programs with teachers in the three cities and is actively looking for ways to foster relationships with local school districts and other learning institutions such as museums and zoos. The loyalty program is very basic and consists of a mailing list gathered from in-store information request cards. The CEO believes that there are many more marketing opportunities available but is not sure how to go about increasing their customer base beyond the three stores.
The production process for MindPlay and purchasing for all three stores is done out of the central office in San Diego. The production manager is responsible for soliciting bids for raw materials that are then shipped to a production facility in Fresno. The manager has had trouble managing production over the last few years as the economy in California has changed so quickly and predicting sales on the limited information available has become difficult. During some fiscal quarters, some stores have too much inventory of MindPlay’s products while other quarters, some stores are falling short of various games and toys. Adding to the manager’s difficulties is the oversight of ordering other products from other educational game and toy suppliers. The manager orders games and toys from sixteen different suppliers throughout the year for all three stores. Currently, the inventory is managed at the central warehouse, and the manager ships the same number of each product to each store at the beginning of every quarter. Because the inventory is controlled centrally, it is difficult to determine what inventory each store has on hand at any given moment. Most of the inventory reconciliation happens quarterly and requires managers at each store to manually take inventory at the conclusion of each quarter. As a result, the manager has noticed increased inventory loss and he also suspects that he is not managing the products in the most efficient manner. He would like a better idea of what product each store has on hand at any time and would like insight in how to better order products and materials for the production and inventory processes.
Currently, there is little communication between stores and the technology at both the stores and the central office is becoming outdated. Most communication with vendors and suppliers is occurring through email and purchase orders are being processed manually. The only connections currently between the locations are via Internet connections provided by a local ISP in each city. MindPlay’s CEO knows that they need to invest in infrastructure to solve some of the problems with the marketing, inventory and processing problems but is also interested in additional technology solutions. The CEO is interested in not only moving their inventory online, but she is also interested in opening stores in Chicago and Dallas. She believes the growing pains her company is already experiencing will be exacerbated by growth outside her region.
Based upon the narrative provided above complete the following deliverables using appropriate systems analysis and design tools and techniques. The focus is on the pertinent issues as they relate to the phases of planning (scope definition and problem analysis) and analysis (requirements analysis). Make assumptions where necessary and document in responses. Please cite any outside sources used which are used:
1. Create a high-level Data Flow Diagram (i.e., Event Diagram) of the proposed MindPlay system identifying necessary external agents, processes, data stores, and data flows (use standard symbols). Provide appropriate explanation of how and/or why you designed the Data Flow Diagram. Note: The Context Diagram and Use-Case Model Diagram from the Midterm exam may be used as references
.
INSERT ANSWER HERE – PLEASE USE A DIFFERENT COLOR OF TEXT FOR RESPONSE
2. Create a high-level Activity Diagram with swimlanes outlining the activities of the proposed system for MindPlay.
INSERT ANSWER HERE – PLEASE USE A DIFFERENT COLOR OF TEXT FOR RESPONSE
3. Summarize, in your own words, the relevant issues related to the storing and tracking of inventory for MindPlay. This may take the form of a bulleted list.
INSERT ANSWER HERE – PLEASE USE A DIFFERENT COLOR OF TEXT FOR RESPONSE
4. If MindPlay were to implement a relational database management system (DBMS) to manage its inventory describe the types of information they would need to store in the database. This should take the form of a high-level discussion in non-technical terms so that your client can understand. Remember, the CEO likely does not have an information systems background and will not necessarily understand the technical database terminology that you are familiar with. Discuss how storing this information would help to alleviate the issues identified in question 3.
INSERT ANSWER HERE – PLEASE USE A DIFFERENT COLOR OF TEXT FOR RESPONSE
5. From the discussion in questions 3 and 4 (specifically the types of information to store) develop a list of the major entities needed in the management of the inventory and provide a brief description of each as well as related attributes. Additionally, provide a narrative discussing how these entities will relate to one another.
INSERT ANSWER HERE – PLEASE USE A DIFFERENT COLOR OF TEXT FOR RESPONSE
6. From the discussion of entities, attributes, and relationships above, create a fully-attributed Entity Relationship Diagram (ERD) to model the functional requirements of the MindPlay inventory database from a logical design perspective. Because your client’s background in database design is quite limited provide a detailed description and justification of the ERD you are proposing. This includes but is not limited to the choice of entities, attributes, primary and foreign keys, and cardinality. Create a second ERD from the physical design perspective by identifying appropriate data types for each attribute and including those in the model.
INSERT ANSWER HERE – PLEASE USE A DIFFERENT COLOR OF TEXT FOR RESPONSE
Milestone‐9
Sample Solution: Physical Data Flow Diagram
Milestone‐7
Object Modeling Sample Solutions
Activity Diagram
System Sequence Diagram
Potential Object List
Potential Object Notes Obj Reason
Annual Salary The yearly salary of a
salaried employee.
X
Attribute of SalaryEmployee
Building A building where employees
work in various rooms.
√
Calendar Year The year for which a United
Way contribution applies.
X
Attribute of
UnitedWayContribution
Contact Address The street address, city,
state, and zip of an
emergency contact.
X
Attributes of EmergencyContact
Contact Home Phone The home phone number of
an emergency contact.
X
Attribute of EmergencyContact
Contact Name. The first name, middle
name, and last name of an
emergency contact.
X
Attributes of EmergencyContact
Contact Work Phone The work phone number of
an emergency contact.
X
Attribute of EmergencyContact
Contract Employee A temporary employee. √
Department An organizational grouping
of employees that fulfills a
business function.
√
Dept ID An abbreviated identifier for
a department..
X
Attribute of Department
Dept Name The full name of a
department.
X
Attribute of Department
DOB An employee’s date of birth. X Attribute of Employee
Emergency Contact A person who should be
contacted concerning a
particular employee in case
of emergency
√
Emp ID A unique, sequentially-
assigned identifier for an
employee.
X
Attribute of Employee
Employee A person who works for the
organization.
√
Employee Address The street address, city,
state, and zip of an
employee.
X
Attribute of Employee
Employee Home
Phone
The home phone number of
an employee.
X
Attribute of Employee
Employee Name The first name, middle
name, last name, and
nickname of an employee.
X
Attribute of Employee
Employee Office
Phone
The office phone number of
an employee.
X
Attribute of Employee
Hire Date The date an employee was
hired.
X
Attribute of Employee
Hourly Employee An employee who is paid a
hourly wage.
√
Hourly Wage The hourly wage of an
hourly employee or a
contract employee.
X
Attribute of HourlyEmployee
and ContractEmployee
Job Title An employee’s job title. X Attribute of Employee
Life Insurance A miscellaneous deduction. X An instance of MiscDeduction
Location Where an employee can be
found.
X
Synonym for room, building,
and site.
Mail Stop A room or an area of an
office where employees can
go and retrieve their mail.
√
Marital Status The marital status (married,
single) of an employee.
X
Attribute of Employee
Maximum Weekly
Hours
The maximum hours per
week that is scheduled for
each hourly employee.
X
Attribute of HourlyEmployee
Misc Deduction A Miscellaneous Deduction
elected by an employee.
√
Permanent Employer The permanent employer of
a contract employee.
X
Attribute of ContractEmployee
Request Date The date of a Miscellaneous
Deduction request.
X
Attribute of MiscDeduction
Room A room where employees
may work.
√
Salary Employee An employee who is paid a
salary.
√
Site A company location
consisting of one or more
buildings.
√
SSN An employee’s Social
Security Number.
X
Attribute of Employee
Supervisor An employee’s supervisor X Attribute of Employee.
United Way
Contribution
A contribution pledged to the
United Way by an employee.
√
Class Diagram
CContext
Data Model
K
Key‐Based Daata Model
FFully Attributed Data Moddel