Database (2) database design

1-Write the relational algebra expressions for the following (using Ç):
branch (branch_name, branch city, assets)
customer (customer_name, customer street, customer city)
loan (loan number, branch_name, amount)
borrower (customer name, loan number)
account (account_number, branch name, balance)
depositor (customer_name, account number)
a) Find the names of all customers who have a loan and an account at bank. 
b) Find all customers who have an account from at least the “Downtown” and the “Uptown” branches. 
2- University schema
Classroom (building, room number, capacity)
Department (dept name, building, budget)
Course (course id, title, dept_name, credits)
Instructor (ID, name, dept_name, salary)
Section (course id, sec id, semester, year, building, room number, time slot id)
Teaches (ID, course id, sec id, semester, year)
Student (ID, name, dept_name, tot cred)
Takes (ID, course id, sec id, semester, year, grade)
Advisor (student ID, instructor ID)
Time slot (time slot id, day, start time, end time)
Prereq (course id, prereq id)
Write the following queries in SQL, using the university schema
a) Find the names of all students who have taken at least one Comp. Sci. course; make sure there are no duplicate names in the result
b) Increase the salary of each instructor in the IT department by 15%. 
c) Insert every student whose tot cred attribute is greater than 75 as an instructor in the same department, with a salary of $15,000. 
3- Refer to the university schema used in Q.2 and write the following queries using Nested subqueries.
a) Find the average instructors’ salaries of those departments where the average salary is greater than $50,000. (Hint: use subqueries in the From Clause)
b) Delete all courses that have never been offered (that is, do not occur) in the section relation. 
4- Deleting a record can be costly to an organization if not done in the right way. Let us assume you are working as a DBA (database administrator) and you used the delete command without specifying a condition in the where clause. What do you think will happen to the record in the database? And in case a record was deleted, is there a way to recover the lost data? Answer should be in your own words.

Database security

Write an essay of at least 500 words discussing how database auditing and monitoring fit within a SOX compliance framework. 

Do not copy without providing proper attribution. This paper will be evaluated through SafeAssign. 

Write in essay format not in outline, bulleted, numbered or other list format.  

Use the five paragraph format. Each paragraph must have at least five sentences. Include 3 quotes with quotation marks and cited in-line and in a list of references. Include an interesting meaninful title.

Include at least one quote from each of 3 different articles. Use the Research Databases available from the Danforth Library, not Google. Place the words you copied (do not alter or paraphrase the words) in quotation marks and cite in-line (as all work copied from another should be handled). The quotes should be full sentences (no more, less) and should be incorporated in your discussion (they do not replace your discussion) to illustrate or emphasize your ideas.

Cite your sources in a clickable reference list at the end. Do not copy without providing proper attribution (quotation marks and in-line citations).

It is important that you use your own words, that you cite your sources, that you comply with the instructions regarding length of your submission 

wk-7

 Assignment 1: 

Examine Alexa’s skill in ordering drinks from Starbucks

Refer to Chapter 12 in the attached textbook:

Sharda, R., Delen, D., Turban, E. (2020). Analytics, Data Science, & Artificial Intelligence: Systems for Decision Support 11E. ISBN: 978-0-13-519201-6. 

Requirement: 

****Separate document for each assignment****

Minimum 300-350 words. Cover sheet, abstract, graphs, and references does not count.

Add reference separately for each assignment question.

Strictly follow APA 7th Edition Format

No plagiarized content please! Attach a plagiarized report.

Check for spelling and grammar mistakes!

$5 max. Please bid if you agree.

Assignment 2: 

Research Apple Home Pod. How does it interact with smart home devices? Alexa is now connected to smart home devices such as thermostats, microwaves, and much more. Find examples of other appliances that are connected to Alexa and write a report.

Refer to Chapter 13 in the attached textbook:

Sharda, R., Delen, D., Turban, E. (2020). Analytics, Data Science, & Artificial Intelligence: Systems for Decision Support 11E. ISBN: 978-0-13-519201-6. 

Requirement: 

****Separate document for each assignment****

Minimum 300-350 words. Cover sheet, abstract, graphs, and references does not count.

Add reference separately for each assignment question.

Strictly follow APA 7th Edition Format

No plagiarized content please! Attach a plagiarized report.

Check for spelling and grammar mistakes!

$5 max. Please bid if you agree.

Assignment 3: 

Practical connection assignment

Refer to the “Required Practical Connection Assignment – Students(1)” word document for instructions. 

Other previous homework done from you has been attached for your reference. 

Requirement: 

****Separate document for each assignment****

Minimum 500-600 words. Cover sheet, abstract, graphs, and references does not count.

Strictly follow APA 7th Edition Format

No plagiarized content please! Attach a plagiarized report.

Check for spelling and grammar mistakes!

$10 max. Please bid if you agree.

  

Assignment 4:

Based on your readings in this course and research on the Internet and other sources, identify and discuss at least two trends or best practices related to key concepts and principles of operational excellence in any field of human endeavor. Use your own words and give credit to any sources referenced in your submission.

Text book attached: 

1. Information Systems for Business and Beyond

2. Information Technology and Organizational Learning Managing Behavioral Change in the Digital Age by Arthur M. Langer

Requirement:

****Separate document for each assignment**** 

Minimum 300-350 words. Cover sheet, abstract, graphs, and references does not count.

Add reference separately for each assignment question.

Double Spaced and APA 7th Edition Format

No plagiarized content please! Attach a plagiarized report.

Check for spelling and grammar mistakes!

$5 max. Please bid if you agree.

project

Project – Part 5 – Modules

Modify the pseudocode design that you created in ITP 100 Project – Part 4 to include at least the following modules.

•    studentID    – to Enter the Student ID

•    calcBill        – to Calculate the Bill

•    prtBill        – to Print the Bill

After the student has finished entering the course titles, the system will calculate and print the bill.

Create a hierarchy chart for the modules.  Save the hierarchy chart as ITP100Project-Part4-Hierarchy-LastName.doc

Save the pseudocode design using the filename ITP100Project-Part4-LastName.doc

Submit for a Grade:

•    Upload the files ITP100Project-Part4-Hierarchy-LastName.doc and ITP100Project-Part4-LastName.doc file to the ITP100_Project_Part4 file upload area.

short answer

 

Forms are often used on business Websites to collect data of various kinds (sales, memberships, mailing lists, etc.). The quality of the data is vital to the success of the business and its ability to use the data appropriately. Using JavaScript for form validation is one line of defense. Validation is often applied to check for a valid zip code, phone number, or product number. Another way JavaScript is applied in a form is to make entering the data easier (hint: focus).

For this thread, select two of the following potential form fields and write the JavaScript you would use to validate or make the data entry easier for the visitor:

  • U.S. phone number
  • Zip + 4
  • Social Security Number
  • A section that asks for the following:
    • First Name
    • Last Name
    • Street Address
    • City
    • State
    • Zip Code
  • Ordering a sweater that comes in any of the following colors:
    • Black
    • White
    • Gray
    • Blue
    • Red

digital forensic

Go online and research some tools that would be valuable in collecting both live memory images and images of various forms off media. Put together a shopping list for your manager that includes tools needed to be purchased. Include a price if applicable.

software engineering report

its a group assignment about dorm management system

1 need 1 page report only due in less than 15 hrs about analysis of similar systems weaknesses , strengths, problems) for https://popartdorms.com/en/ , https://www.ciu.edu.tr/dormitories,https://www.emu.edu.tr/dormitories)

The final Protfolio project

The Final Portfolio Project is a comprehensive assessment of what you have learned during this course.  

There are several emerging concepts that are using Big Data and Blockchain Technology. Please search the internet and highlight 5 emerging concepts that are exploring the use of Blockchain and Big Data.

Conclude your paper with a detailed conclusion section. 

The paper needs to be approximately 5-8 pages long, including both a title page and a references page (for a total of 7-10 pages). Be sure to use proper APA formatting and citations to avoid plagiarism.

Your paper should meet the following requirements:

• Be approximately 5-8 pages in length, not including the required cover page and reference page.

• Follow APA6 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.

Create a conference room scheduler PHP web application.

Requirements:

  • Allow users to login to the site
  • Allow users to register to the site
  • Users should be able to reserve rooms for a specified date and time range
  • Validate user input
  • Display error messages when appropriate.
  • List conference room reservations sorted in date and start time order
  • Allow two display options: 
    • All-display all conference room reservation schedules; past and future
    • Future-display conference room reservations that are scheduled in the future only

* Do not allow reservations outside of business hours or during the weekends

A copy of the DB is attached

Note: you can make any modifications to the DB you feel you need