rephrase attached file 300 words so that it show less than 10% on turnitin.com. Provide me the report.
SQL Statements
In this assignment, you are to write Oracle SQL statements to:
- Create a table.
- Accept user input to populate the table.
- Check if the data has been added to the table properly.
Use the following as references for your assignment.
- Date, Time Exercise (with answers)
Help with writing SQL commands to format date and time. - Text Processing Exercise (with answers)
Help with formatting the output and allowing users to communicate with the database. - Sequence Exercise (with answers)
Help with writing SQL statements to create sequence and alias.
This assignment consists of three parts:
- Write Oracle SQL statements to create a table called Employee with the following attributes and associated data types.
Employee
EmployeeIDCHAR(9)LNameCHAR(15)FNameCHAR(15)PhoneNoCHAR(10)
- Write Oracle SQL statements to insert new records to the Employee table. The program should do the following:
— Trident Bookstore —
Please enter the Employee ID: Jimmy2345
Please enter employee First Name: Jimmy
Please enter employee Last Name: William
Please enter the phone number of the employee: 714-456-3456
Note: Add at least 2 records of the data
- Check whether data has been loaded to the table properly.
Oracle live SQL does not support some of the commands such as ACCEPT. It is helpful to learn these commands though.
Assignment Expectations
- Copy the Oracle SQL commands to a Word document, and turn it in to the dropbox. Please note that there is no need to turn in the output of the commands, since you would most likely get a “Commands not supported” error message because of reserved words ACCEPT in your SQL.
- Apply what you have learned in this module to accomplish all three parts of the assignment.
Proposal RollOut
The following resources will be used to complete your assignment:
- Taking screenshots
- Windows 10: Snipping Tool or Snip & Sketch
- MacOS: Grab tool
- Web Browser
- Microsoft Word
The new team was hired to support your research proposal and you have been tasked to setup the online sharing environment. The assignment below covers the expected items to be completed before the team starts working.
Management wants to make sure you have taken the right steps, so it is asking for screenshots to ensure you have done set this up correctly. You are expected to provide a Word document with screenshots and explanations as to how you completed each of the steps below.
- Provide evidence of signing to Office 365. A screenshot showing you logged in will suffice. Please note that for the rest of the assignment, you should use the same account. You are allowed to use a personal account such as Hotmail.com or outlook.com. However, you are encouraged to login using your Chamberlain email.
- Once you are logged in, access OneDrive and create a folder named “Research Team”.
- Upload the Word, Excel, and PowerPoint documents you created during your research inside the “Research Team” folder.
- Create a new Word Document in OneDrive. Name it “welcome” and write one or two paragraphs welcoming your new team.
- Take a screenshot of how you could share this document with others. There is no need to actually share the document.
- Finally, in the Word document where you are adding the screenshots, add a new page and type a minimum of 300 words explaining your journey in the course. Specifically talk about what you learned, how you are thinking of applying that knowledge, and how this can be useful in your healthcare career.
- Name your final document as “YourName_COMP150_W8_MyJourney” and submit it.
Microsoft Word
Microsoft Word. Share with the class your favorite feature, anything new you have learned or even the topic you decided to pursue and research. Which features you considered the most important and why? Tell us how you customized your documents not only in design or style but with other features such as bullet list, footers, and header.
Write a statement to create a JFrame object with
- Write a statement to create a JFrame object with a title of “My GUI Application”.
- Given the object you created in question 1,write a statement to specify the window size to be 300 pixels wide and 400 pixels high?
- What would you need to do to the object from question 1 to make sure that the application containing the object terminated when the object’s window was closed?
- Explain how a FlowLayout manages its display area.
- Write a Java statement to have the object from question 1 manage its display area by dividing it into 3 rows which have 4 columns each.
- Explain how a BorderLayout manages its display area.
The frame object from question 1 uses a BorderLayout by default. Write Java statements to create a JTextfield object and place it into the bottom part of the frame object’s
- Describe the sequence of steps needed to create 3 labels and place them side by side in the top part of a frame which is using a BorderLayout.
- What happens if you add two different button objects to the SOUTH part of a frame using a BorderLayout?
- Write a sequence of statements to create 2 JButton objects, and do what is needed so the two buttons appear one above the other on the left side of the display associated with a frame object which is using a BorderLayout. Create ALL objects required.
- What packages would need to be imported for the code from question 11?
1. Write a Java application to display the following GUI. At this point you are only implementing the display. We are not ready to make the calculator actually do any calculations!
2. Write a Java application to display the following GUI. At this point you are only implementing the display.
Computer science Python program
I need an ipynb program that matches all the specifications
Write a paper with min of 7 pages APA Format with Summary, 7 References.
Research the costs associated with the following items when implemented by a firm with 1,000 employees and 100 servers (since you would research only one resource for each of these in real life, you will need to obtain three (3) costs for each item):
1. Managed antivirus software (not open source) licenses for 500 workstations
2. Cisco firewall (other than residential models from LinkSys)
3. Tripwire host-based IDS for 10 servers
4. Java programming continuing education training program for 10 employees
5. Checkpoint firewall solutions
Once the costs have been identified, compare and contrast the costs for each item. Justify your choice for each item (cost, service, vendor experience, etc.). Additionally, identify if any of these require contingency plans due to known and unknown risks, and factor that cost in as well.
Human Computer Interaction Discussion 2
which of the interaction types do you feel most influence interface design challenges?
After reading Chapter 3, which of the interaction types do you feel most influence interface design challenges? You are required to write a statement that is LIMITED to 150 words. This is an opinion question; therefore, research is not required. Should you cite the work of others, please provide the source of your opinion in APA format.
Discussion 300 words
Describe two cryptographic applications and how they are used in Information System Security.
SQL Discussion Response 2
Please see below the discussion in response to the original question asked and respond as a peer using 150 or more words.
Original Question: Explain SQL and its functions. What do you enjoy the most about learning SQL? What you find the most difficult?
Peer Response:
SQL is a query language and one of the most popular database languages, mostly due to it not being too difficult to learn. Each SQL database systems have data definition language and data manipulation language. The data definition language is for database creation, change and maintenance. The data manipulation language (DML) is used for computing data within a database. The DML can also support functions like COUNT, which counts the number of rows meeting the selection criteria. CURRENT_DATE will return the current system date. AVG computed the total value of the column given. Some very basic and standard commands include, SELECT, INSERT, FROM, CREATE and DROP.
I enjoyed how simple it was to understand the language. I have taken courses with other languages and this has been the least confusing. Being able to continue to build on what you already have is the best part. The most difficult was understanding the normalization forms. This was a big hurdle for me but once I got more of an understanding it became simpler to understand how I needed to do the diagrams. Also some of the syntaxes. in the trucks assignment it took me hours, and I mean hours, to fully understand where I was going wrong with some of them. But now I’ve become more aware of what to use and where to use it.
