Functional Dependencies

/in /by

Assignment Instructions

Required Reading
1. Pratt – Concepts of Database Management – Chapter 5

Assignment:
Complete the Premiere Products Exercises in Chapter 5 on page 180/181 (exercises 1 & 2). The % after an instruction indicates the % of grade for this exercise.

Include the below numbers and letters to organize the submission do not include the questions.

1) For Exercise 1
A) Copy the definition of functional dependency (from the text), then explain it in your own words including an example not in the text or this exercise. (5%)

B) Submit one complete set of functional dependencies (use the notation found on the bottom of page 162, ensure all fields are included at least once). (15%)

In your own words and using field names from this exercise, explain one row of functional dependencies (this demonstrates an understanding of how to apply the concept).

C) Submit the 3NF table(s) (use the shorthand table notation found on page 34, and 162). The tables and fields on those pages are similar to those assignment. That is because they are also based on Premier Products example. The main point in referencing those pages and tables is to provide examples of the notation format there may be similarities in content but base your submission on fields in the exercise. (15%)

D) For each 3NF table:  
Include a statement, in your own words that explains the primary key selection: why is that field a good choice for the primary key? (10%)<o:p>

2) For Exercise 2
A) Submit one complete set of functional dependencies (use the notation found on the bottom of page 162, ensure all fields are included at least once). (15%)

In your own words and using field names from this exercise, explain one row of functional dependencies (this demonstrates an understanding of how to apply the concept).

B) Submit the 3NF table(s) (use the shorthand table notation found on page 34, and 162). (15%)

C) For each 3NF table:  
Include a statement, in your own words that explains the primary key selection: why is that field a good choice for the primary key? (10%)

Writing APA/Org/Clarity/Spelling (15%)

Discussion Question: The Economy

/in /by

Chapter 17 highlights what is, in many ways, the very basis for sociological thought, the Economy. Many of the first sociologists based their theories on how the economy of society works.  So your text talks about two major types of economies though there are many more out there, Socialism and Capitalism. In keeping with what is happening in our world today, I have posted two videos for you, One is of Bernie Sanders talking about what is wrong with Capitalism, and the other is Rand Paul talking about what is wrong with Socialism. While this is not going to be a discussion about politics, I am interested to hear your thoughts on these two very different perspectives in the light of the information presented in your text.
– What types of capitalism do we observe in our society today?
– Where could we benefit from socialism in our society?
– What is contributing to the underemployment and unemployment in our society? (Please use data to support your claims)
????
????
Macionis, J. J. (2018). Sociology (17th ed.). Pearson Education, Inc.

Question Development

/in /by

Consider a question about a child or adolescent development that you find interesting. Then, identify three empirical articles that have attempted to answer the question.  For example, perhaps you would like to understand whether playing Pokemon GO influences a teens academic achievement. You might find articles that attempted to answer that question by 1) interviewing teens who play Pokemon GO and ask them about their experiences, and their academics; 2) gathering academic achievement data on teens who play Pokemon GO and teens who do not play Pokemon GO and compare two; and 3) conducting brain scans on teens as they play Pokemon GO to determine if the results reveal brain activity that would promote academics.
Assignment Instructions:
This week you will examine how we can answer the same research question in many different ways. Once you find three research articles that pertain to your interest, write a brief reflection including the following:
        Present your question.
        Explain how each study tried to answer the question/topic, noting the strengths and weaknesses of each study
        Offer another suggestion or explain which approach you found the most useful and why.
Length: 10-13 slides

Your presentation should demonstrate thoughtful consideration of the ideas and concepts presented in the course by providing new thoughts and insights relating directly to this topic. Your response should reflect scholarly writing and current APA standards. And on graduate level writing.

reading assignment

/in /by

these are the two reading Helen Armstrong, Introduction: Revisiting the Avant-Garde from Graphic Design Theory: Readings from the Field: ArmstrongIntro
https://openlab.citytech.cuny.edu/langecomd3504sp2020/files/2018/08/ArmstrongIntro.pdf

Ellen Lupton & J. Abbott Miller, Counting Sheep, Period Styles, Language of Dreams and Language of Vision from Design Writing Research: Writing on Graphic Design: LuptonMillerDesignWritingResearch
https://openlab.citytech.cuny.edu/langecomd3504sp2020/files/2018/08/LuptonMillerDesignWritingResearch.pdf

Here are the questions to which you should respond:
Our first readings by Helen Armstrong, Ellen Lupton and J. Abbott Miller consider developments in graphic communication from ancient and recent history. Why are rudimentary communication methods relevant for contemporary information systems? Why should contemporary designers concern themselves with archaic writing, counting, or printing techniques? What facts or details from these texts provoke ideas for developing new design strategies? 3 to 4 paragraphs no longer than that