1) What to SUBMIT: You will submit a document to include all the following infor
ID: 3621172 • Letter: 1
Question
1) What to SUBMIT:
You will submit a document to include all the following information. When you include tables or figures, you should properly name using captions.
1. Background
a. Describe about the system you are developing.
b. It should include one sentence about the background of company information, one sentence about the current problem, and one or two sentences about the goal of the system.
2. ER-Diagram
a. Based on the requirements, you will design database using ER-model using VISIO.
b. It should include all entities and attributes, primary keys, and foreign keys.
c. You should properly explain about each entity and attributes (using tables might be easy to describe).
3. Database Table Design
a. Based on the ER-Diagram, design tables in 3NF (table format might be easy to show).
b. Choose a proper data type and length for each attributes.
c. Generate or create DDL scripts and include in the report.
4. Input / Output Forms and Reports Design
a. Generate Input forms per table and several output forms based on needs.
b. You can use ACCESS form design and report generator or Visual Studio windows forms. Even it is not working with SQL*Server, it should be consistent with database design.
c. To provide menu system, you can use ACCESS form design or Visual Studio .NET framework.
d. For each input and output, you will submit screen capture images.
5. Testing results
a. Describe how to test your system (using table to describe steps, expected results and success or not).
b. It should include testing the input and output forms and reports, testing data as a table format, and the testing results.
2)THE CASE
KoKo’s Canine Pet Club
CASE BackGround
Six months ago, Caedee Hannah found herself facing a dilemma. As a result of a chronic illness, KoKo, her beloved schnauzer, required medication, a special diet, and daily exercise. While the medication and special diet were easy to accommodate into a busy life style, ensuring that KoKo received daily exercise was another matter. Although KoKo’s daily exercise usually took the form of a walk around the neighborhood, Ms. Hannah’s friend, lan, would walk KoKo on the days when Ms. Hannah was extremely busy. Ms. Hannah’s friends and neighbors liked the pet walking idea so much that they approached Ms. Hannah and Ian about walking their dogs as well. What began as a neighborhood walking service has now become a fledgling, yet growing, metropolitan area business. She needs you to build Client and Pet forms, Client and Pet tables, Walker Schedule and Client List reports, and several queries.
CASE Scenario
KoKo’s Canine Pet Club is a dog-walking service, catering to caring, yet busy, pet owners. The service proves very popular with pet lovers who recognize the value of providing their pets with daily exercise. Although the service was only started six months ago, it currently provides pet walking services for 50 pets and is registering, on average, 5 pets per week. Paperwork is increasing, and Caedee Hannah, the service’s owner, needs a better record-keeping system.
During a meeting with Ms. Hannah, she explains to you that a new client must register with the service. During the registration process, the new client provides basic information about his pet(s), chooses a preferred walk time for his pet(s) and specifies a walker preference. During this time, a dog-walking fee is determined and recorded on the pet registration form. The dog walking fee varies by pet and is based on the pet’s size, temperature, and the number of pets the owner has. The pet owner can request that his pet be walked in the early morning, late morning, early afternoon, late afternoon, or early evening hours. Available walk times are currently kept on a clipboard by the phone. However, Ms. Hannah wants the available walk times, as well as walker, client, and pet information, kept in the database that you are building.
Ms. Hannah’s record-keeping needs are simple. She requires a database that tracks her clients, their pets, available walk times, and the pet walkers. Ms. Hannah gives you a partially completed database and requests that your build and populate Client and Pet tables, create several relationships, design Client and Pet forms, design Walker Schedule and Client List reports, and construct several queries.
Explanation / Answer
I Giving Leave Management System project details.
Project title: Leave Management System
ABSTRACT:
Leave Management System (LMS) is a web-based automated tool, integrated into the Clearbenefits application to effectively address all issues pertaining to Leave Management at various levels of the organizational hierarchy. This tool enables an employer user to keep track and manage the status of the applied leaves of his/her immediate and recursive subordinates, as per their leaves/holidays’ setup via admin mode of this application. On the other hand, it simplifies the employee leave requisition process, thus enabling an employee to keep track of the updated status of his/her eligible leaves as notified by the organization from time to time. Thus LMS is a highly productive tool that simplifies the manual task of leave management process, saving organization’s time and resources.It consists of the following modes:
Employer mode:
Set holidays
Set weekends
Set leave types
Set maximum leaves for designations
The employer sets the holidays. To set the holidays he needs to specify the name and the dates (from date and to date). In general holidays will set for the festivals and for some specific days. The employer will also set the weekends. In general the weekends are Saturday and Sunday. The employer will also set the leave types also. Leave types means say for example sick leave, journey leave. The employer will give a name for this leave type. The employer will also set the maximum number of leaves for the designation. It means that the employees who are having the designations should be allowed to take maximum number of leaves.
The supervisor performs the following operations.
Leave apply
Leave decide
The supervisor can apply the leave to his supervisor. This functionality is same as the normal employee. Once he applies the leave then that will be forwarded to his supervisor through a mail. A mail will be send to both the supervisor and his supervisor.
The supervisor is having an extra functionality than the employee. That is the supervisor can see the leaves applied by his subordinators. Here he will check the leave then he decides whether the leave is accepted or rejected or in pending state.
Employee:
The employee performs the following operations.
Leave apply
The employee can perform only one operation that is applying leave. In this operation if he wants a leave then he opens the site and he will apply the leave. At the time of applying leave he needs to specify the leave type and the description and the dates. Once he finishes the operation then the system will send a mail to both the employee and to his supervisor. The mail will be send if the status of the leave is changed.
if you want to remaining details please do another post.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.