Monthly Archives: June 2023

Research Paper:

 The final portfolio project is a three- part activity. You will respond to three separate prompts but prepare your paper as one research paper. Be sure to include at least one UC library source per prompt, in addition to your textbook (which means you’ll have at least 4 sources cited).

 Start your paper with an introductory paragraph.

Prompt 1 “Blockchain” (2-3 pages): Explain the major components of blockchain. Be sure to include how blockchain is affecting a global economy and how you see it growing in the future.

 Prompt 2 “Big Data” (1-2 pages): Describe your understanding of big data and give an example of how you’ve seen big data used either personally or professionally. In your view, what demands is big data placing on organizations and data management technology?  How does big data affect a global economy.

Prompt 3 “Government and Policies” (1-2 pages):  Discuss the role government plays in a global economy.  Also, look at what policies are currently in place and then discuss what policies should be put in place.

Conclude your paper with a detailed conclusion section. 

The paper needs to be approximately six to eight pages long, including both a title page and a references page (for a total of eight to ten pages). Be sure to use proper APA formatting and citations to avoid plagiarism.Your paper should meet these requirements: 

• Be approximately six to eight pages in length, not including the required cover page and reference page.
• Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
• Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.
• Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

Discussion:

There is a relationship between policy evaluation and production identification, policy evaluation and policy implement, and policy evaluation and policy formulation.  Can you explain this relationship and why they are important?

Please make your initial post and two response posts substantive. A substantive post will do at least two of the following:

• Ask an interesting, thoughtful question pertaining to the topic
• Answer a question (in detail) posted by another student or the instructor
• Provide extensive additional information on the topic
• Explain, define, or analyze the topic in detail
• Share an applicable personal experience
• Provide an outside source (for example, an article from the UC Library) that applies to the topic, along with additional information about the topic or the source (please cite properly in APA)
• Make an argument concerning the topic.

At least one scholarly source should be used in the initial discussion thread. Be sure to use information from your readings and other sources from the UC Library. Use proper citations and references in your post.

attached below are the instructions

Please see the attached documents. Please do not bid if you do not know how to complete this. 

Thanks,

  Developing SQL Statements to Query Existing Data 

Answer the 6 questions who, when, where, why (all together in 1-2 sentences) then HOW and WHAT in 2-3 sentences EACH -we need detail), then write an objective summary using the sample in the resource manual as a template

Please read the full instructions to complete paper . NO NO plagiarism it will be n turnitin.com

 QUESTION #2

Given the business rule(s) you wrote in Problem 1, create the basic Crow’s Foot ERD. 

SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image013.jpg

Make sure that the file is saved AS ch2_question2_Deleon.doc

————————————————————————————————————————————–

QUESTION #3

 Using the ERD you drew in Problem 2, create the equivalent object representation and UML class diagram. (Use Figure 2.4 as your guide.) 

SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image017.jpg

Make sure that the file is saved AS ch2_question3_Deleon.doc

—————————————————————————————————————————

 QUESTION #5

The DealCo relational diagram shows the initial entities and attributes for the DealCo stores, which are located in two regions of the country. Create the basic Crow’s Foot ERD for DealCo. 

SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image019.jpg

Make sure that the file is saved AS ch2_question5_Deleon.doc

——————————————————————————————————————–

QUESTION #7

 The Tiny College relational diagram shows the initial entities and attributes for the college. Create the basic Crow’s Foot ERD for Tiny College. 

SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image022.jpg

Make sure that the file is saved AS ch2_question7_Deleon.doc

——————————————————————————————————————–

QUESTION #8

 The Tiny College relational diagram shows the initial entities and attributes for the college. Create the UML class diagram that reflects the entities and relationships you identified in the relational diagram. 

SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image022.jpg

Make sure that the file is saved AS ch2_question8_Deleon.doc

—————————————————————————————————————————

 QUESTION #9

Typically, a hospital patient receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between PATIENT and ORDER. Similarly, each order can include several medications, creating a 1:M relationship between ORDER and MEDICATION.

a. Identify the business rules for PATIENT, ORDER, and MEDICATION.

b. Create a Crow’s Foot ERD that depicts a relational database model to capture these business rules. 

Make sure that the file is saved AS ch2_question9_Deleon.doc

——————————————————————————————————————————

 QUESTION #11

Using the ERD from Problem 10, create the relational schema. (Create an appropriate collection of attributes for each of the entities. Make sure you use the appropriate naming conventions to name the attributes.) 

 United Broke Artists (UBA) is a broker for not-so-famous artists. UBA maintains a small database to track painters, paintings, and galleries. A painting is created by a particular artist and then exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. Similarly, a painting is created by a single painter, but each painter can create many paintings. Using PAINTER, PAINTING, and GALLERY, in terms of a relational database: 

Make sure that the file is saved AS ch2_question11_Deleon.doc

———————————————————————————————————-

 QUESTION #12

Convert the ERD from Problem 10 into a corresponding UML class diagram. 

United Broke Artists (UBA) is a broker for not-so-famous artists. UBA maintains a small database to track painters, paintings, and galleries. A painting is created by a particular artist and then exhibited in a particular gallery. A gallery can exhibit many paintings, but each painting can be exhibited in only one gallery. Similarly, a painting is created by a single painter, but each painter can create many paintings. Using PAINTER, PAINTING, and GALLERY, in terms of a relational database: 

Make sure that the file is saved AS ch2_question12_Deleon.doc

———————————————————————————————————————-

QUESTION #14

 Create a Crow’s Foot ERD to include the following business rules for the ProdCo company:

SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image025.jpg

a. Each sales representative writes many invoices.

b. Each invoice is written by one sales representative.

c. Each sales representative is assigned to one department.

d. Each department has many sales representatives.

e. Each customer can generate many invoices.

f. Each invoice is generated by one customer. 

Make sure that the file is saved AS ch2_question14_Deleon.doc

————————————————————————————————————-

QUESTION #16

 Create a Crow’s Foot ERD for each of the following descriptions. (Note that the word many merely means more than one in the database modeling environment.)

SEE IMAGE IN LINK: https://cnow.apps.ng.cengage.com/ilrn/books/co3ds13h/Images/image027.jpg

a. Each of the MegaCo Corporation’s divisions is composed of many departments. Each department has many employees assigned to it, but each employee works for only one department. Each department is managed by one employee, and each of those managers can manage only one department at a time.

b. During some period of time, a customer can download many ebooks from BooksOnline. Each of the ebooks can be downloaded by many customers during that period of time.

c. An airliner can be assigned to fly many flights, but each flight is flown by only one airliner.

d. The KwikTite Corporation operates many factories. Each factory is located in a region, and each region can be “home” to many of KwikTite’s factories. Each factory has many employees, but each employee is employed by only one factory.

e. An employee may have earned many degrees, and each degree may have been earned by many employees. 

Make sure that the file is saved AS ch2_question16_Deleon.doc

 Character-Analysis ProgramProblem Statement:Design a program that asks the user to enter a string.  The string will then be displayed back to the user.  This is followed by determining the number of alphabetic characters, numeric characters, lower_case letters, upper_case letters, whitespace characters and then displaying them.  The user should be given additional chances to enter additional strings, and each time a string is entered, the above process is to be performed.  The inputting is to stop, when the user enters “end” as the input string. At that point, total number of alphabetic characters, numeric characters, lower_case letters, upper_case letters, whitespace characters are to be displayed and the program terminated.
An algorithm:1. Prompt the user to enter a string at the keyboard2. As long as the string is not “end”      2.1 Display the string, along with an appropriate message      2.2  Examine the current character of the string         2.2.1 If it’s alphabetic, update the alphabetic_counter and the total_alphabetic_counter         2.2.2 If it’s numeric, update the numeric _counter and the total_numeric_counter         2.2.3 If it’s a lower_case letter, update the lower_case _counter and the                  total_lower_case_counter 2.2.4 If it’s a upper_case letter, update the upper_case _counter and the                  total_upper_case_counter 2.2.5 If it’s a whitespace character, update the whitespace _counter and the                  total_whitespace_counter          2.2.6 Continue from step 2.2 with the next character until done with this string       2.3 Display the  alphabetic_counter,  numeric _counter,  lower_case _counter,  upper_case _counter, and  whitespace _counter, each on a separate line,              and each along with an appropriate message       2.4  Prompt the user to enter another string at the keyboard 3. Display the  total_alphabetic_counter,   total_ numeric _counter,       total_lower_case _counter, total_ upper_case _counter, and   total_ whitespace _counter,      each on a separate line, and each along with an appropriate message 4. Stop==================================================================================NOTE 1: The program will process alphabetic, numeric, and whitespace characters only.NOTE 2:A sample program run is attached below.  It illustrates user’s interactions with the program: Lab SIX – Sample Program Run.pdf  =======================================================================You need to set up a     Python solution that is     complete and     workable.  

For your solution to be     complete, you must

• Prompt the user for the specific input data asked for within the problem statement
• Does the appropriate processing on the entered input data
• Provide the output data asked for within the problem statement to the user

For your solution to be     workable,

• Your solution should be free of any type of errors (syntax, run-time, logic)
• You may want to develop an algorithm first, using pseudocode or flowchart
• You do NOT need to turn in any algorithm

========================================================================Grading rubric:

• You’ll receive full credit, if 
  • your program
    • compiles and runs with no problems 
    • produces the expected output
• You’ll receive partial credit, if 
  • your program
    • compiles and runs with no problems 
    • produces partial output (that is, incomplete output)
• You’ll receive 25% of the points, if your program will not compile
• You’ll receive 30% of the points, if your program compiles but has a run-time problem
• You’ll receive 40% of the points, if your program produces logic error(s)
• You’ll receive 50% of the points, if your program compiles and run, but no functions are used

 1 page 

After having the opportunity to complete the course, what would you change and why? What topic particularly caught your interest and what do you want to know more about?  Last, but not least, if you could share with the next class one piece of advice about this class, what would it be? Please note that this pertains to the class, the materials, flow/organization, etc.  Your comments may be shared with incoming students with no identifying information. Thank you and good luck on your educational journey!

(No participation replies required but encouraged!)

I have this exam consisting of 23 questions; questions consist of multiple choices and few coding.

The time limit is 60 minutes.