Hands-on database 2nd edition steve conger pdf download free






















Bookmark Us. Search Our Site. Popular Posts Download Storia di chi fugge e di chi resta. L'amica genialeBy Elena Ferrante. Download Storia di chi fugge e di chi resta. L'amica Gen Download Ebook Warleggan Poldark By Winston Graham From currently, locating the completed website that offers the completed books will cert Download Ebook The Purpose of Man: Designed to Worship Following your need to always fulfil the ideas to acquire everybody is currently simp Are you still puzzled with thi Myles Munroe.

Myles Munroe is s Richardson Come join us to locate your favo Recent Posts. Text Widget. A management information system does not have to be as fast as a transaction database. Diff: 3 Page Ref: 27 9 When gathering data for a new database what kinds of documents should you look at and why? Answer: You should look at all the documents that are relevant. Forms are important because they are used to gather the data the database will need.

Reports can reveal data that must be included in order to create the summaries that the business requires. Procedures and manuals can help understand how the data is acquired and processed and what rules are applied to it. Even memos and quarterly statements can be useful by providing context for the use and purposes of the data to be stored in the database.

Diff: 3 Page Ref: 23 10 Explain what documentation you should keep from gathering data about the database. Answer: You should keep copies of all the documents looked at, with the notes explaining obscure terms and abbreviations. You should also keep copies of all your interview notes. Copies of questionnaires and summaries of the responses are also important. In addition, any notes about work shadowing and observations about the use of the data should be kept.

Diff: 3 Page Ref: 36 11 Explain some of the advantages of Cloud database services. Answer: Cloud services offer companies the opportunity to expand their infrastructure without worrying about maintenance and the expense of the equipment.

Cloud services are especially useful for handling peak loads. For example, a retailer may have twice the normal load during the Christmas holiday. Rather than paying for infrastructure that is idle most of the year, they can purchase cloud services to handle the peak.

Millions discover their favorite reads on issuu every month. Give your content the digital home it deserves. Get it to any device in seconds. Publish for free today. Go explore. Who can use this report? Students may come up with other relevant questions. Create a questionnaire for the users of the form in practice 2 with 4 or 5 questions. Your goal should be to understand how and when they use the form. Who can submit a help request? Mark all that apply. Faculty b. Staff c.

Administrators d. IT Staff e. Students 2. How are requests prioritized? By the order in which they are received b. Both 3. Is each computer assigned to a single user? Yes b. How do you assign requests to the IT Staff? Based on the nature of the task b.

By whoever is next on the list. You have an interview with a manager at the company. List at least three questions you would ask him about this form. Here are some possible questions: Are the fields with an asterisk required? What do you do with the account information once it is entered? Do you have rules for forming a password? What do you do if a user forgets his or her password?

Can a password hint be anything? You are going to create a database to track clubs and activities on campus. Make a list of some of the types of documents you would like to look at. Some relevant documents might include club charters, memos, emails, club minutes, meeting agendas, etc. Tomorrow you are going to interview several students who belong to various clubs mentioned in practice 6 above, and their faculty advisors.

You will have one hour to conduct the interview. Think about what questions you might ask and make a plan like the one Sharon made on page 20 for the interview. Here is a possible answer. The trick here is to ask questions relevant to the database, and not questions like what is your club about?

How long has your club existed? Question How many clubs are there total? What exactly would you like to track about the clubs? Would you want to track which students are members of each club? Are there privacy issues that should be considered?

Who would have access to the database? Are there institutional or legal rules that the database would have to follow? How do you hope that a database will improve the situation for clubs at the school?

Time for follow-up questions. Create a questionnaire to follow up on the interview in question 7. The questions in the questionnaire are, to a large degree, dependent on what questions one asked in the interview and the answers one imagines.

Here is a possible example: 1. Would you mind if your name was listed in the database as a member of the club? Which of the following do you think a club database should do? List times and places for club meetings b. List club officers c. List club meeting minutes d.

List club members e. List club descriptions f. List club requirements 3. Do you think a club database would: a. Improve the management of campus clubs b. Add an unnecessary layer of work and overhead to campus clubs c. Think about some job that you have held. Can you list two or three exceptions—that is, things you did that were different than the standard procedures, shortcuts or one-time variations?

Have you ever seen an instructor make an exception for a class or a student? List the rules and the exceptions and briefly comment on why a database should or should not allow for each of them.

An example of rule and exception: the rule is that all homework must be turned in on time. The exception: allowing late homework in the case of illness or certain circumstances. Another Example: The rule at the bakery is that everyone is charged the listed price for goods. The exception is that sometimes family can have an item for free or at a discount. What would somebody doing a job shadow on your day observe? This is pretty open. Ideally the response will involve a narrative with some detail, listing typical and perhaps some untypical tasks done on a work day.

Wild Wood Apartments 1. Make a list of questions that you would ask about these forms and reports. It is possible for students to come up with additional questions, but here are some questions that could be asked: Lease Form. Do the start date and end date refer to the length of the lease? Is each lease attached to only one person? Rent Payment Form Date. In the rent payment, why are some lease numbers missing? What constitutes a late payment? Is there a fine or penalty for a late payment?

Is there a grace period? At what point do you take other action like eviction? Do you have a rule about how soon a problem must be resolved? Quarterly Report. What is the difference between maintenance and repairs? What is meant by wages? Is that for the manager?

Identify the stakeholders for Wild Wood Apartments. Create a plan for an hour-long interview with representatives of these stakeholders.

Then meet with the instructor to discuss possible answers to the questions. Here is a possible plan:. Question What are the two or three things you would like most to get out of this database? What is the hardest part about your job currently? What part of the report takes the most time?

How do you think this database will affect your relation to Wild Wood apartments for good or ill? Describe how you handle maintenance requests. Create a questionnaire of at least 5 questions for the managers of the 20 apartment buildings. These questions can vary and can include variations of questions asked about the form. Here is an example of a questionnaire: 1. How do you currently keep track of rent payments?

In an Excel worksheet. In a spiral notebook. Explain: 2. How much time do you currently spend filling out monthly reports?

More than 6 hours 3. Rank the following functions of an apartment management database in order of importance. Tracking rents Tracking leases Tracking new and departing tenants Tracking maintenance requests Generating monthly reports 4.

Approximately how many maintenance requests do you receive a month? Between 1 and 5 B. Between 6 and 10 C.

Between 11 and 15 D. More than 15 5. About how many changes in tenants do you handle a month? This includes both tenants moving in and out of apartments.

More than Look at the Job shadow report. Do you see any exceptions to the general rules? Do you see any new business rules uncovered? What additional questions arise from the report? Exceptions The tenant who pays late but always pays. The old woman who needs until the 10th. Business Rules. Make a list of questions you would ask about the data in them.

What are the possible conditions? How extensive can your notes be? Do you buy all albums? If not, how do you choose?

Album Sales Date. Would you like to gather more information about customers? Stakeholders should include: Vince Customers Sellers those who sell him albums 3. Prepare an interview with Vince and two of his best customers. One who both sells albums to Vince and buys, and one who mostly just buys. Question How do you price your albums?

Do you have a method or an exact markup? When you purchase albums do you look up values online or in a book, or do you just go by experience?



0コメント

  • 1000 / 1000