All posts by : chebby

Complete the attached

This exercise is more suited for in person instruction, obviously, so let’s do it this way.  Try to execute the exercise with another person, spouse, friend, etc.  Explain in a half page or more what the exercise was meant to accomplish.  No references required.  If you can’t perform the exercise with another person, simulate the exercise by yourself and reflect on what you were supposed to learn.

To apply all acquired knowledge in the last Project Assignments to create a Database Scheme. For this project, the ERD is provided to you.Deliverables:

• SQL Script with your name as follows: YourLastName_Project_Ph3.sql.
• MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.
• ZIP file to include the two files mentioned above.

Required Software:

• MySQL DBMS by Oracle. MySQL Community Server and MySQL Workbench.
• Follow Step 1-3 for your Course Project Phase phase 1, to install the required software components.

Lab Steps:Step 1: Analyze the ERD for a student information system provided below. Be alert for the specifications provided for: 1) Entities, 2) Attributes, 3) Primary Key, and 4) Relationships.  You will need to have a clear understanding for these components to create your database using MySQL. Step 2: Create a New Database in MySQL, Produce SQL File, Drop Table

• Create a new Database, as you did in your Course Project Phase 1 deliverable and you already created a database using the MySQL DBMS.  Reference the attached video (Course Project Ph1 Video.mp4), for a demonstration to create a new Database using MySQL. This video was initially presented to you for phase 2 of your project.  Also, reference the supplemental text: Available for Free download as part of our UC Library.  MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill. ISBN: 978-0-07-160550-2.  Link to UC Library: http://search.ebscohost.com/login.aspx?direct=true&AuthType=shib&db=nlebk&AN=291311&site=eds-live&ebv=EB&ppid=pp_ii
• Utilize the SQL dialect you learned so far in this course for MySQL.  Use the file supplemental textbook:  MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill, as supplement your knowledge of the MySQL dialect. 
• Create your SCRIPT file to be named: YourLastName_Project_Ph3.sql.

Step 3: Include the following commands at the tops of your scripts:

• SET FOREIGN_KEY_CHECKS=0;
• DROP TABLE IF EXISTS STUDENT;
• DROP TABLE IF EXISTS CAMPUS;
• DROP TABLE IF EXISTS ROOM;
• DROP TABLE IF EXISTS COURSE;
• DROP TABLE IF EXISTS INSTRUCTOR;
• DROP TABLE IF EXISTS APPROVED_INSTRUCTOR;
• DROP TABLE IF EXISTS CLASS;
• DROP TABLE IF EXISTS STUDENT_GRADE;
• SET FOREIGN_KEY_CHECKS=1;

Step 4: Create Tables in your database

• Create a new Table for each of the entities provided to you in the ERD diagram in Step 1.
• Add a column to represent each attribute addressed in the ERD diagram in Step 1.
• Designate Primary Key, as noted in the ERD diagram in Step 1.
• Designate a Foreign Key relationship between the tables, as noted in the ERD diagram in Step 1.
• Enable referential integrity on the relationships, as needed.
• Enable cascade updates as needed on the relationships.

Step 5: Designate Data Types. Update the data type as needed to enforce the domain constrain of the data. This needs to be completed for every column for all tables.

• Dates: they should have a date data designation type.
• Surrogate keys: shall be auto-numbered
• Character type: shall have a character data designation type.

Step 6: Column Constraints Designation.

• Grade designation must be of one of these values as follows: A, B, C, D, F, I, W, E (E=enrolled, and W = withdrawn).
• Student’s first and last names are not to be designated as NULL.
• Course Credit hours shall be BETWEEN one and four.
• The instructor first and last name must NOT be NULL
• Course name designation has to be UNIQUE and must not be NULL type.

Step 7: Data Table Addition

• Use the INSERT operator to add minimum 2-3 rows of data per each database.
• You are free to use any values you might like for each of the columns.
• NOTE/ Reminder: you are required to add data to the parent table prior to adding any data to child tables, as referential integrity is enabled.

Step 8: Executing your SCRIPT

• Must incorporate the COMMIT command at the end of your Script
• Must incorporate the SHOW TABLES command, to display the table you created. At the end of the script created.
• Must incorporate the SELECT statement to show data allocated for each table. This would be added at the end of the script.
• EXECUTE your SCRIPT.
• Copy and paste your OUTPUT into your MS Word file as follows: YourLastName_Project_Ph3_Output.doc

Step 9: Upload your work

• Upload ZIP file to include the two files as follows: 1) SQL Script with your name as follows: YourLastName_Project_Ph3.sql, and 2) MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.

Rubric:

• Tables Created: create a table for each entity as noted in the ERD diagram in Step 1. 5 points
• Columns Created: create a column for each attribute as noted the ERD diagram in Step 1. 5 points
• Primary Key designation: primary key addressed for all tables with unique constraints specified as column properties. 5 points
• Data Types: Addressed for each attribute. Should include: 1) Date data type incorporated, 2) Surrogate Key Automated, 3) Numeric data shall be numeric type, 4) Character data shall have a character type. 5 points
• Relationships Created, as noted in the ERD diagram in STEP 1. Relationships shall be enabled for referential integrity and cascade updates. 10 points.
• Data Added per row: 5 rows of data for each table. 10 points
• Column Constraints Added: As noted in the description for the project. Checked by adding rows with invalid values. Should take into consideration constraints as follows: 1) student name cannot be NULL, 2) course credit hours are restricted to allocations between 1-4, 3) course name is unique and NOT NULL, 4) instructor last name and first name can NOT be NULL, and 5) grade restrictions to the following values: A,B,C,D,F,I,W, E. 10 points

psychology prep

The assignment is based off the lab so both need to be done by same person ? the power point is the answer the last question in assignment 3

Within the Discussion Board area, write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.

Answer the following questions:

• What facilitated your learning in this course?
• What impeded your learning in this course?
• What could you have done to better to improve your learning?
• If you were to take this course again, would you do anything differently? What and why?
• Where are you now in your understanding of the course concepts versus where you were at the beginning of the course?
• Did you learn the things that you thought you would learn?
• Did you learn something that you did not think you could or would learn? What? How did you feel once you learned it?
• What aspect of the course did you find most interesting?
• What do you think you can apply most to your other courses?

Homework is 3 parts: A, B, and C

Part A:

A small restaurant only provides burger and sandwich. It has two chefs and one waitress. Chef A is assigned to make burger and Chef B make sandwich. Waitress’s job is to present customer’s order to the right chef. You are required to use {{{{{Command pattern}}}}} to illustrate the order process. As we discussed in lecture, in this case, the invoker is responsible for not only storing and dispatching command, but choosing appropriate receiver as well. The receiver class (chef) contains only one method MakeFood(), it will display on screen the food is being made.

1) Give the UML class diagram

2) Provide the implementation code of the UML class diagram given in JAVA.  The main application should display the following message 

“Welcome, would you like to order a burger or sandwich?”, then based on customer’s choice, store and dispatch the order to the right chef.

Note: Show in the diagram how you used Command pattern to implement the code 

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

Part B: 

A house automation system uses four devices to automate operations. The four devices are

a) A Weather instrument that provides current weather (rain, cloud, sunny, etc)

b) A CoffeePot

c) A Calendar that provides date, day, time info and a timer

d) A Sprinkler

Use{{{{{{{{{{{{{{{ Mediator pattern}}}}}}}}} to coordinate these four devices and automate the following operations

i)    During weekdays, start to make coffee at 6am

ii)   At the weekend,  if weather is sunny, start to make coffee at 7am or at 8am

iii) During June to October, start sprinkler twice a day (6am, 8pm) and run it for 15 mins. But sprinkler will not start if it is raining.

1) Give the UML class diagram

2) Provide the implementation code of the UML class diagram given in this part of question using JAVA.

Note: Show in the diagram how you used Mediator pattern to implement the code 

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

Part C: 

Use the {{{{{{{{{{Observer pattern}}}}}}}}}}}}}}}}} in a situation where registered flight ticket buyers are notified when ticket price is lower than or equal to a certain amount specified by the buyer at the registration time. For example John expects to be notified only when round trip DTW <> NYC on 12/24 <> 12/29  reaches $210.  Different buyer may have different expectation for the same flight. At registration time with a given flight each buyers provides his/her name, from city, destination city, departure date, return date and expected price.  Similarly, a flight is defined by {from city, destination city, departure date, return date and price}

1) Give the UML diagram using the observer pattern.  In the pattern, there should be one single ConcreteObserver class. Each buyer will be an instance of that class.  There should also be one single concreteSubject class. Each flight will be an instance of that class. You are requested to give the details of each class in the diagram (i.e., methods, properties, whether the methods/properties are private, public, or protected).

2) Give the implementation code of the UML diagram. You must use PULL mode to implement the notification. The PULL mode usually involves two steps, first notifies the investor the flight price reaches his expectation and then he retrieves the flight information anytime he wants in the future. In the main application, you are requested to create three flights (as instances of the concretSubject class): 

{Chi, SFO, 01/15/2022, 01/26/2022, $420}, {DTW, NYC, 02/03/2022, 02/10/2022, $240}, {FLL, DFW, 04/23/2022, 04/28/2022, $300} You are also requested to create two buyers: John and Maria. John will register with the first flight with an expectation of $350 and second flight with an expectation of $200.  Maria will register with the second flight with an expectation of $220 and third flight with an expectation of $280. Also in the main program, testing the scenarios of receiving notification.

Note: Show in the diagram how you used Observer pattern to implement the code 

create the database and load the data. The initial data could be either new data or existing data imported from your SQL scripts. You also establish database objects this week and give the users that you’ve identified access applicable to the database 

The following are steps for the implementation 

1. Install the DBMS.
2. Tune the setup variables according to the hardware, software and usage conditions.
3. Create the database and the tables. (Every table must have a primary key, which uniquely identifies rows in the table and validation rule).
4. Establish relationships between tables.
5. Load the data into the tables.
6. Create at least three forms (splash screen and Main switchboard are optional).
7. Create at least four transaction requirement Queries
8. Create data views and reports.

 Attach are references

 You are the webmaster for the Republican Party National Committee. Prepare a risk assessment analysis for your website. Some questions to consider:

• Who is likely to attack your site?
• When are attacks likely to occur?
• What sort of attacks might take place?
• How can you best minimize attacks and protect the integrity of your site?

Write between 200-300 words. Also, include references or citations if any

What is the Basic SQL SELECT?

USE THE FOLLOWING FILE TO DO THIS HOMEWORK.

Create a method which accepts a  number as a parameter and returns the Fibonacci series up to that  number. The Fibonacci series is a series of numbers in which each number  is the sum of the two that precede it. Starting at 0 and 1, the  sequence looks like this: 0,1,1,2,3,5,8,13,21,34, and so on. Your method  should use the appropriate naming and all variables should be declared  with appropriate data type and initialise with sensible values. For  example, for the input 13, the method will return 0 1 1 2 3 5 8 13.