DATA MANAGEMENT – APPLICATIONS

Competencies:

4018.1.1: Conceptual Models to Physical Schemas – The graduate

creates conceptual data models and translates them into physical

schemas.

4018.1.2: Create Databases – The graduate creates databases

utilizing SQL Data Definition Language (DDL) in MySQL environment.

4018.1.3: Create/Modify Tables and Views – The graduate creates

and modifies tables and views employing SQL Data Definition

Language (DDL) in MySQL environment.

4018.1.4: Create Primary Keys/Foreign Keys and Indexes – The

graduate creates and modifies primary keys (PKs) and foreign keys

(FKs) and indexes with SQL Data Definition Language (DDL) in MySQL

environment.

4018.1.5: Populate Tables – The graduate populates tables with

insert, update, and delete using DML in the MySQL environment.

4018.1.6: Create Simple and Complex Queries – The graduate

creates simple Select-From-Where (SFW) and complex 3+ table join

queries with Data Manipulation Language (DML) in MySQL

environment.

Introduction:

 For this assessment, you will be creating models,

databases, tables, and query reports for a smartphone application.

To

complete this assessment, you will be using SQL Fiddle, an online SQL

tool, to test run the MySQL code that you will develop for parts C

through G. After running the code, you will take a screenshot of your

results, which should be copied into the document that you will submit

to TaskStream for this assessment. Instructions for how to use this

tool for each part of the assessment is included in the attached

document “SQL Fiddle Instructions.” Please note that for each part of

the assessment, there are explicit instructions on what SQL code you

will need to copy and paste into SQL Fiddle panels to run your

test.

The work you complete for each part of the assessment (i.e.,

the design models/diagrams, tables, written explanations, SQL script

code, and screenshot results from running your SQL scripts in SQL

Fiddle) should be saved as a single *.pdf (Portable Document Format)

file that you will submit to TaskStream.



Scenario: 

You are the database designer and developer for a burger

stand that wants to create a smartphone application where customers

can order meals. First, you will design a normalized entity-relationship 

(E-R) logical database model to store data related to the customer,

products, and product order. Next, you will create three tables with

primary and foreign keys that are derived from your E-R model. Once

the tables have been built, then you will create views and indexes to

protect and fine-tune query performance. You will populate each of the

tables with sample data. Finally, you will create both a simple “selectfrom-where”

(sfw) query and a complex join query to produce

meaningful reports on individual orders and summaries to determine

which products sell the best.



Requirements:

A. Construct a normalized model to represent the burger stand

smartphone application database that supports the scenario above

by doing the following:

1. Using the unnormalized order form (“Receipt” attached

below) for the ordering database as a reference, produce

the final logical schema for this database by doing the

following:

Note: You can design the tables using any method of your choice (e.g.,

using a drawing tool using tables).

a. Design a table that is in 1st normal form

and fulfills the following requirements:

• The table should have a primary key

that uniquely identifies the records.

• The values in each of the columns

should be atomic.

• There should be no repeating groups.

i. Write a one paragraph

explanation of how you designed

the table.

b. Design at least two tables that are in 2nd

normal form and fulfill the following

requirements:

• The tables should meet all of the

requirements for the 1st normal form.

• Redundant data appearing in multiple

rows should be eliminated with the

creation of the new tables.

• Each of the tables should be related 

using foreign keys.

i. Write a one paragraph

explanation of how you designed

the table

c. Design at least three normalized tables that

are in 3rd normal form and fulfill the following

requirements:

• The tables should meet all of the

requirements for the 1st and 2nd normal

forms.

• Fields that do not depend on the

primary key or any other field should be

eliminated.

• There should be at least three

resulting tables, one for customer

information, one for product information,

and one for order information.

i. Write a one paragraph explanation of

how you designed the table

B. Using the tables you designed in 3rd normal form from part A1c,

create an entity-relationship (E-R) diagram that fulfills the

following requirements:

Note: You can use any drawing tool of your choice to create the

diagram.

• Entities should be drawn that represent each of the tables from

the 3rd normalized form.

• All appropriate fields (i.e., attributes) should be entered into

each of the entities.

• Primary keys (PK) and foreign keys (FK) should be

appropriately designated.

• Data types for each attribute (Numeric, Fixed, Char, Varchar,

or Timestamp) should be appropriately designated.

• Relationships drawn between the entities should be labeled

with a relationship name.

1. Provide a written explanation for the following:

a. Explain why you selected the entities represented in

your diagram.

b. Explain how you determined the relationships between 

these entities.

c. Explain what the cardinality is for each of the relationships.

C. Develop the SQL code for each of the tables you designed in part A

and refined in part B by doing the following:

1. Provide the SQL code you wrote for each table.

Note: Make sure all of the primary and foreign keys and data types are

assigned to each of the fields in the create table SQL code.

a. Demonstrate that you have used SQL Fiddle to test your code

from part C1 by providing a screenshot of your

results.

D. Using the table that contains the customer information fields,

develop SQL code to create a View that shows all of the customer

information with the First Name Middle Initial, and Last Name

concatenated (CONCAT()) to show full name as one field by doing

the following:

1. Provide the SQL code you wrote to create the View for the

customer information.

a. Demonstrate that you have used SQL Fiddle to test your code

from part D1 by providing a screenshot of your

results.

E. Using the table that contains the product information fields,

develop SQL code to create an Index for the product name field by

doing the following:

1. Provide the SQL code you wrote to create the Index for the

product information.

a. Demonstrate that you have used SQL Fiddle to test your code

from part E1 by providing a screenshot of your

results.

F. Using all of the tables you developed in part C, develop SQL code to

populate each of the tables by doing the following:

1. Provide the SQL code that inserts data into all of the tables.

Note: Make sure that data is inserted first into the table(s) with

primary keys before inserting data into the other tables.

a. Demonstrate that you have used SQL Fiddle to test your code 

from part F1 by providing a screenshot of your results.

G. Using the tables you populated in part F, develop SQL code to

display the values in a requested table or tables by doing the

following:

1. Provide the SQL code for the simple (sfw) queries to display all

of the data in each of the tables you have created and

populated.

a. Demonstrate that you have used SQL Fiddle to test your code

from part G1 by providing a screenshot of your

results.

2. Provide the SQL code for a complex join query to display all of the

information contained in the attached “Receipt.”

a. Demonstrate that you have used SQL Fiddle to test your code

from part G2 by providing a screenshot of your results.

H. Submit parts A–G as a *.pdf (Portable Document Format) 

Write a four to five (4-5) page paper in which you:

1. Suggest three (3) specific change management techniques that Shimon
   Kornfield should have used in order to manage the morale of the team
   assigned to the Yad Vashem memorial site project.
2. Outline the essential steps that Shimon Kornfeld could have taken in
   order to ensure that all team members learned of any proposed changes.
   Provide the rationale and justification for each step outlined. 
3. Assess the criticality of the timing of communication in the success
   of the Yad Vashem memorial site project. Support the response with
   three (3) specific examples.
4. Assume that two (2) key members of the team were replaced during the
   executing phase of the Yad Vashem memorial site project due to family
   crises. Discern actions Shimon Kornfield could take in order to
   establish trust and gain credibility with the remaining project
   participants.

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with
  one-inch margins on all sides; citations and references must follow APA
  or school-specific format. Check with your professor for any additional
  instructions.
• Include a cover page containing the title of the assignment, the
  student’s name, the professor’s name, the course title, and the date.
  The cover page and the reference page are not included in the required
  assignment page length. 

The specific course learning outcomes associated with this assignment are:

• Apply the concepts of project leadership to implement sound
  leadership practices and effectively lead high-performance teams in a
  project environment.
• Develop productive relationships with project participants to gain
  the trust of project team members and build the personal credibility
  required for effective leadership.
• Use technology and information resources to research issues in project management leadership.
• Write clearly and concisely about project management leadership using proper writing mechanics.

Paper B: a matrix mapping of a key IT-related organizational (or personal) ethical issue concerning privacy and organizational policy designed to correct the ethical issue.

The first step of this assignment is an opportunity to analyze a key IT-related organizational (or personal, if you are not in the job force) ethical issue, related to privacy, subject to relevant laws, regulations, and policies. Both of the following sites provide sources, and an excellent backdrop for issues relating to privacy protection and the law.

See EPIC Privacy Issues at: http://epic.org/privacy/ See List on left and/or: EFF Privacy at https://www.eff.org/issues/privacy [see list below in center on this page].

This includes sub-topics discussing information privacy, privacy laws, applications and court rulings (case law is usually an extension of the basic law based on the facts from specific cases and real-world court decisions), and key privacy and anonymity issues. While the sites provide many interesting topics, be sure to focus on our class IT topics.

1. Use the template below and the list of suggested workforce privacy topics from one of the sites above to produce a matrix to map a key organizational ethical (or personal, if not in the job force) issue and how this issue is affected by laws, regulations, and policies. Use the list of normative ethics below to help you complete the matrix. Choose any three (only three) of the following list of twelve (12) principles of normative ethics described below.
2. Prepare the Ethical Issue matrix (single-space in the cells) and include the following explanation (200 words) —double-space your narrative—below the matrix:

1. 1. Why I chose the dilemma;
   2. Why I chose the three principles; and
   3. An analysis of the research used to identify the actions in the matrix.

The completed matrix allows you to weigh the different issues involved and assign a rank as to the importance of the actions based on the effect on the stakeholders.

1. Submit the matrix for grading to the LEO Assignments Module.
2. Indicate appropriate APA in-text and source citations for all sources. In addition to critical thinking and analysis skills, your assignment should reflect appropriate grammar and spelling, good organization, and proper business-writing style.

Normative Ethics List

Autonomy: is the duty to maximize the individual’s right to make his or her own decisions.

Beneficence: is the duty to do good both individually and for all.

Confidentiality: is the duty to respect privacy of information and action.

Equality: is the duty to view all people as moral equals.

Finality: is the duty to take action that may override the demands of law, religion, and social customs.

Justice: is the duty to treat all fairly, distributing the risks and benefits equally.
Non-maleficence: is the duty to cause no harm, both individually and for all.
Understanding/Tolerance: is the duty to understand and to accept another viewpoint if reason dictates doing so is warranted.

Publicity: is the duty to take actions based on ethical standards that must be known and recognized by all who are involved.

Respect for persons: is the duty to honor others, their rights, and their responsibilities. Showing respect others implies that we do not treat them as a mere means to our end.

Universality: is the duty to take actions that hold for everyone, regardless of time, place, or people involved. This concept is similar to the Categorical Imperative.

Veracity: is the duty to tell the truth.

A sample template for the matrix is shown below. To reconstruct the sample template, you may use the Table Tool in MS Word or copy and paste this template.

Ethical issue:
Stakeholders	(Principle 1)	(Principle 2)	(Principle 3)
1
2
3
4

Step 1: Identify the ethical issue that you want to analyze, as described above. An example might be the falsification of your personal profile in a social networking site.

Step 2: Identify the stakeholders involved. You, someone who reads your personal profile in a social network site, potential employers, etc. Be sure that each stakeholder category is unique and not similar to another category you use.

Step 3: Choose any three (only three) of the Normative Ethics principles that might apply to your issue such as autonomy, publicity, and veracity.

Step 4: Identify how the ethical issue affects each stakeholder based on the principles you identified. Put this statement in the matrix next to the stakeholder.

Sample Completed Matrix

Ethical issue: falsifying your profile on a social networking site
Stakeholders	autonomy	publicity	veracity
1: Yourself	You have the duty to maximize the right to make your own decisions.	You have the duty to take actions based on ethical standards that must be known and recognized by all who are involved.	You have the duty to tell the truth
2: Other users of the networking site	They have the duty to make their own decisions	They make these decisions based on ethical standards that should be recognized by the person falsifying their profile	They assume that the person falsifying the profile has the duty to tell the truth.
3: The social networking site	The autonomy of the site is limited by law (Goldman, 2007)	Users of social networking sites are content publishers, as such the site must take actions based on legal and ethical standards and must notify users of these standards so they are known by all.	As providers of content the site must conform to the laws regarding truth or be held responsible for legal issues as defamation (making harmful false statements about someone else) or copyright infringement. (Goldman, 2007)

Reference:

Goldman, E. (2007, May). Social Networking Sites and the Law. Retrieved from

http://www.ericgoldman.org/Resources/socialnetworkingsitesandthelaw.pdf

[Note: Plug the above URL directly into your browser, in its entirety to open]

The second step of this assignment requires that you write an organizational policy (or personal policy, if you are not in the job force) to correct the IT-related ethical issue that you had previously described, where you mapped a key organizational or personal issue and identified how the digital ethical issue was affected by relevant laws, regulations, and policies.

The following elements must be addressed:

You may take a look at other policies to see how they are written. While the following site: http://www.sans.org/security-resources/policies/computer.php, provides credible examples of templates for policies, an Internet search may provide other templates, however there is no need to copy a template for this assignment, as the template should only be utilized to provide guidance regarding the following headings.

Your policy should include appropriate information for the following major headings:

• Overview of the policy – an Introduction
• Purpose of the policy – the aim of the policy
• Scope (roles and responsibilities of stakeholders) – who is involved in policy execution.
• Policy Points to follow – (Note: you should be aware that a policy only describes “what,” the staff of an organization will do, while a procedure describes “how,” the staff of an organization will accomplish a required action. As a result, this section should only discuss the specific measures, needs, or changes to behavior within the organization in terms of policy points, i.e., what they must do to conform to the policy. Any procedures that are needed to assist in doing the “what,” are usually included by reference later in the policy – procedures should not be included in the policy points).
• Sanctions/enforcement of policy – what happens in case of non-compliance

This assignment requires a minimum of three external references. Indicate appropriate APA source citations for all sources you use.

In addition to critical thinking and analysis skills, your paper should reflect appropriate grammar and spelling, good organization, and proper business-writing style.

Prepare a 4-6 page, double-spaced paper with your Ethical Matrix and your Organizational or Personal Policy (if not in the job force).

comment on what two different classmates posted, (Each comment should be 80 words.)

Post 1

As an audience we take for granted the hard task of editing a film to make it cohesive and or flow in an interesting manner. One way to do this cohesively is to use continuity editing; an idea is to convey a story as plainly, capably and logically as can be. To make it more interesting way of editing is discontinuity editing; which disrupts the law of continuity editing by searching to get shifts among shots that are not smooth, unbroken, or intelligible. Dreamscapes by Sean McBride is an animated film that uses animation to capture the spirit of people’s dreams. Altogether Dreamscapes want to show us the spontaneity of dreams and dreaming by using continuity and discontinuity editing.

Discontinuity editing is seen by different styles of art and music in Dreamscapes. The film starts with wistful music paralleled with hand painted stars and faces, suddenly a voice says space and time and diagrams of the brain plus scattered marimba music disorients us out of our dream state.  It fits with what the person says, but is surprising in what we actually see. Another severe cut and we see an animated three-dimensional long view shot, an expansive view of the surroundings of a roadway and in comes a racing car, with soft electronic jazz. Each scene has a different look and feel so I feel the editing is not as clear as it could be.

Continuity editing is seen before each’s new dreamer thoughts. For example a man is seen flying on a rocket pack from the first 3-d animation scene into next collage animated scene. We don’t know where one dream starts and one dream ends. There is a scene where a chalk drawn man drowns in pitch darkness, then can breathe in water in pitch startling light to contrast a woman recalling a sunny day on a beach with those who are alive and those who die in fast sketch form. From these scenes we can assume that there is a “people die and people live theme”. An old video game style animation pops out with a child voice over and peppy music. Although we feel it is unusual after the death theme the director places a sense of transportation in between the scenes in order to make a smooth transition with a car train into a point of view of a moving car seeing a suburban neighborhood.

post two.

This week I chose to watch The Big Charade (2003). This short film turns out to be a movie trailer satire that follows one man’s life and the influence that the game of charades has along the way. Continuity editing is not found to be a key element of this short film. Continuity editing refers to the smoothness of sequential flow; this is important for achieving a logical coherence and transition over space and time. Since a movie trailer is a collection of short clips of significant scenes throughout a movie, there tends to be a lack of continuity. In this short film, the director had to jump from childhood to adulthood very quickly in order to better explain the story. There were several changes in setting that did not flow with much context. One of the goals of this satire was to appeal to a wide range of audiences. In order to do this, they presented the film as a hybrid movie with genres such as action, romance, and suspense. This combination of types of movies, although meant as a joke, make it hard to follow along with the plot of the movie. For these reasons I would assume The Big Charade used the approach of discontinuity editing to break the rules of traditional continuity and use less-than-coherent transitions between shots.