Perform normalization process to convert un-normalized table

Assignment Help Computer Engineering
Reference no: EM131486498

Assignment

Question 1

a) We had learned to recognize the Human-Computer Interaction (HCI) factors during all phases of SDLC and again, in Week 10, we had learned more about HCI (HCI history, user interface, usability, human factors, feedback, etc.) The HCI is a very important aspect in computer information technology and it is considered as a layer of communications and interactions between humans and the computer.

We had been discussed in Week 10 and understood about the reasons why the study of HCI has become increasingly important for all four phases of SDLC: Planning, Analysis, Design, and Implementation. Please identify and explain in at least one example to see what would happen to the next phase and/or the entire project if systems analysts do not include users in one of these four phases.

b) You are a project manager at L & D Inc., specialized in information technology and network engineering. One of your junior systems analyst came to you for an advice of a technology to capture user information requirements. He described to you that he had talked with his client several times in the past week to define user information requirements. Each time he thought he had captured user information requirements, they've already changed. Finally, he thinks his clients do not even know what they want for their system.

1. Give your junior systems analyst an advice of a technology that he could use to capture user information requirements.

2. Explain to him how this technology can help him to better define users' information requirements.

For this question, please limit your response to a maximum of one page.

Clarification:

Students should take the word "technology" as being defined in several dictionaries as a scientific method, technique, theory, or practice to solve a practical problem. I copy here some definitions of the word "technology" from several dictionaries that you might refer to answer your question.

• The application of science, especially to industrial or commercial objectives.
• The scientific method and material used to achieve a commercial or industrial objective.
• The application of practical sciences to industry or commerce.
• The methods, theory, and practices governing such application a highly developed technology.
• The use of scientific knowledge to solve practical problems, especially in industry & commerce.
• The specific methods, materials, and devices used to solve practical problems.

c) As we learned in Week 5 lectures, Data Flow Diagrams (DFDs) are used to describe communications between the system and the outside entities and the flow of data or information into and out of a system. There are 4 main elements that are used to construct context-level diagrams, level-0 diagrams, level-1 diagrams, etc.

1. List these 4 main elements and briefly describe their functions?

2. Identify which elements could or could not be in the context-level diagram and which elements could or could not be in the level-0 diagram?

Question 2

Michael, who is a restaurant owner, wants to be able to receive clear feedback on the systems used to manage his restaurants.

Design a display that shows an acceptable way to tell Michael that input to his system was accepted. Make sure that all three types of following of feedback messages are covered.

1. Action successful.
2. An error in the user entry.
3. Please wait messages, indicating that a response time of more than 5 to 10 seconds will elapse.

Question 3

A summary of business activities of a "Course Registration System" for enrolling courses for students and for enrolled class lists for faculty members at an online university is as follows:

An academic department provides information on offered courses. Students request enrollment in offered courses and the system sends to each student an enrollment schedule. Faculty members receive enrolled class lists when the registration period is complete.

1. Draw a context-level diagram for the "Course Registration System"

2. Explode the above context-level diagram by drawing the logical data flow diagram level 0 showing all the major processes.

Question 4

A local community is hosting several charity events during Spring 2017 and you are tasked to design an entity-relationship diagram (ERD) for the situation described as follows.

Many volunteers can participate in many different charity events and one person, called the charity events coordinator, assumes the role of overseeing these charity events.

You must (1) draw the ERD, (2) handle many-to-many relationships, if any, in the ERD using knowledge learned in Week 7 lectures and (3) identify primary keys for each entity in the ERD.

Question 5

Consider the following agent sales report in which:

1. Each agent covers only one state but each state may be assigned to many agents
2. Each agent may have many customers
3. Each customer has only one store but each store may service many customers
4. There is a one-to-one correspondence between "Customer ID" and "Customer Name" and between "Store ID" and "Store Location".

AGENT-SALES-REPORT

Agent ID

Agent Name

Agent
Covered State

Customer ID

Customer Name

Store
ID

Store Location

Sales Amount

A100120

Alexander Gabay

Virginia

C504181

Jones Smith

312

Richmond

12000

 

 

 

C504182

Kelly Walker

312

Richmond

2000

A100125

Marc Thomas

Oregon

C167120

Frank Barnes

465

Elkton

5000

A432102

Allen Mays

California

C017215

William Kelly

978

Los Angeles

3000

 

 

 

C017216

Bruce Kents

900

Santa Ana

43000

A236100

George Brown

Florida

C246911

Hilton Jackson

201

Miami

15000

A901227

Amy Hartley

Maryland

C303554

James Phillips

315

Baltimore

25000

Perform the normalization process to convert the above un-normalized table to

1. First normal form (1NF)
2. Second normal form (2NF)
3. Third normal form (3NF)

Please show all your work. Please show each step along the way and identify primary keys, if any, in each table in each step.

 

Reference no: EM131486498

Questions Cloud

Equilibrium under perfect competition : Explain elaborately the principle of long run equilibrium under perfect competition.
Keynesian model of national income determination : Explain the key assumptions behind the consumption function in the basic Keynesian model of national income determination.
Requesting major case analysis powerpoint : Requesting Major Case Analysis PowerPoint or Prezi Presentation on: United Parcel Service (UPS) Logistics company Georgia.
Health care economics health demand and supply : Discuss the primary manner in which these concepts impact the world of health care economics health demand and supply, elasticity, resources, health measures.
Perform normalization process to convert un-normalized table : Perform the normalization process to convert the above un-normalized table to First normal form (1NF) Second normal form (2NF) and Third normal form (3NF).
What is the administrative fee for the year : Mark and Parveen are the parents of three young children. Mark is a store manager in a local supermarket. His gross salary is $75,000 per year.
Explain how source plan address recruitment of diversity : Explain how a source plan address recruitment of diversity, culture and unique thought
What should be your need for life insurance : You are a dual-income, no-kids family. You and your spouse have the following debts (total): mortgage, $200,000; auto loan, $10,000; credit card balance.
What are the dimensions and medium of the artwork : Does its medium affect the content? What are its formal elements ?Is it abstract, naturalistic, idealistic, realistic, or a combination?

Reviews

Write a Review

Computer Engineering Questions & Answers

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

  Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

  Security policy document project

Analyze security requirements and develop a security policy

  Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd