All posts by : chebby

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.

 What technologies and/or businesses do you think will be disruptive and change the way things are done in the next few years? 

• Initial posts should be 250 to 450 words minimum
• Response posts should be 150 words minimum
• Your posts should be of substance and include additional research;  there should be at least two paragraphs that address the topic
• Use APA format for any quotations or citations you use to support your answer

 1. Create a database named “Bookstore” and tables, using the following E-R diagram.

E-R diagram is given in attached file.

 1You could create the database on AWS using RDS, or you could create your database on your local machine. 

2. Create a website for access your database, and include some functionalities, like: 

• insert records to each table, you may need to update other tables when you need to insert a record to a table. 

• query records from each table using different columns

 • delete records from each table, you might need to update other tables when you delete a record from a table. 

3. You could use any framework to develop your website, for example: 

• if you are familiar with Python, you could use Flask or Django 

• if you are familiar with javascript, you could use Node.js