23F-A2 SO (1)

The Developers team also wants you to ensure that emails are converted to lowercase after an update operation. Currently, new insertions are guaranteed to have lowercase emails, but there is no such guarantee for legacy emails. Therefore, the team wants to ensure that emails are being retained in a lowercase irrespective of any changes in the database. Create a new TRIGGER called email_update for the USERS table that runs before an UPDATE operation. Task Create a TRIGGER to run on the USERS table before any UPDATE operation.

Create user Peter, Brian and Cindy, create group Family and Friend. Add user Peter and Brian to the Family group, add Cindy to the Friend group. Set up password for all three users. Log in as Peter, create a file “Peter-file1”, set up permission to allow Brian to read and modify the file, but not Cindy. Verify your set up to see Peter and Brian can read and modify the file, but not Cindy. Take screenshot of your configuration.

Create another application/class named EmployeeDatabase that allows you to store anarray that acts as a database of any number of Employee objects up to 25. While the userdecides to continue, offer three options: to add a record to the database, to delete a recordfrom the database, or to change a record in the database. Then proceed as follows:If the user selects the add option, issue an error message if the database is full.Otherwise, prompt the user for an Id. If the Id already exists in the database, issuean error message. Otherwise, prompt the user for rest of the inputs and add the newrecord to the database.If the user selects the delete option, issue an error message if the database is empty.Otherwise, prompt the user for an Id. If the Id does not exist, issue an error message.Otherwise, delete the record.If the user selects the change option, issue an error message if the database is empty.Otherwise, prompt the user for an Id. If the requested record does not exist, issuean…

Assignment: Staywell Student Accomodation  I don't understand what I need to do here, its in mySQL. Help would be appreciated!

Create a MYSQL Database named 'db'Create a MYSQL User named 'dbuser' with a password 'dbpass' Grant Insert, Delete, Update and Select privileges for 'dbuser' on 'db' Create a MYSQL Table on database 'db' and name it as 'students' with the following field and field propertiesField Name Field Type Field Size Additional İnformationStudent No Varchar 6 Primary keyName Varchar 20 Surname Varchar 25 birthdate date

Submit a write up that describes the steps of creating a database of Certificates using MongoDb. Be sure to include any commands that need to be executed. Also include a description of how querying would be accomplished to select only those certificates with the word "Microsoft"

Using the appropriate command in the mongo shell, update the document with the ID “20032-2020-ACME” in the collection “inspections” in the database “city” with the information below. Key Value business_name "New ACME Flowers" result "Business Re-opened" comments "Flowers after the explosion"

If you are unclear where the update.txt file is stored on your computer, you may want to print a copy for safekeeping.

Please use PHPMyAdmin for the database and XAMPP

Task 5: The Developers team also wants you to ensure that emails are converted to lowercase after an update operation. Currently, new insertions are guaranteed to have lowercase emails, but there is no such guarantee for legacy emails. Therefore, the team wants to ensure that emails are being retained in a lowercase irrespective of any changes in the database. Create a new TRIGGER called email_update for the USERS table that runs before an UPDATE operation.

Hello Bartleby I need help with this assignment for my Database Management class. Thank you   SQL - D3 (8 weeks)     No unread replies.No replies. Capture the output of these queries and upload your output screenshot. Run as a script, copy and paste the output to word, and take its screenshot and paste in paint, save the file, and upload the screenshot file. You can also use the following instructions for embedding images: How to embed an image in Canvas textbox . 1. Display the customer number, customer name, order number, and order date for each order. Sort the results by customer number.  2. Display the customer number, customer name, order number, and order date for all orders. Include all customers in the results. For customers that do not have orders, omit the order number and order date.  3. Create a view named TOYS that consists of the item number, description, units on hand, and unit price of each item in category TOY.   4. List customer number, customer name, rep name,…

Chapter 17 How to manage database security Exercises using the My Guitar Shop Database Use Microsoft SQL Server Write a script that creates a user-defined database role named OrderEntry in the MyGuitarShop database. Give INSERT and UPDATE permission to the new role for the Orders and OrderItems table. Give SELECT permission for all user tables. 2.Write a script that (1) creates a login ID named “RobertHalliday” with the password “HelloBob”; (2) sets the default database for the login to the MyGuitarShop database; (3) creates a user named “RobertHalliday” for the login; and (4) assigns the user to the OrderEntry role you created in exercise 1.

If you are unclear of the location of the update.txt file on your computer, you are strongly encouraged to print at least one duplicate of this document.

The idea of the project is to develop a simple Android app with real-time database. you decide your topic, what your app to be about. Four major functions are expected to be available in the app. These functions are Insert, Read, Update, and Delete data. You are required to use Google Firebase to implement the database.   The application allows the user to create a new object (Insert)   The application allows the user to delete information for an existing object. (Delete)   The application allows the user to browse existing information (Read)   The application allows the user to update existing object information (Update)   Application quality (functionality, design and user interaction, stability …)   use Google Firebase to implement the database   XXXXXXXXXXXXXXX plz other than (task manger) or (to do list) XXXXXXXXXXXXXXXX

Hello, I need to find the size of one (1) document within a collection called 'emails' that is within a database called 'enron'.  We are using the MongoDB shell.  I have provided an image that shows the DB, collection, and the details of one document within emails is at the top of the screenshot.  The command used to get that returned all 5,000+ documents but I need just one.  Please assist.

Create a new user account with readWrite permission for your database using MongoDB

Create a file named view_roster.php that allows the user to view the current roster including all elements including any pictures that have been uploaded. This page should NOT require authentication to view since the user cannot modify the database from this page. This page should also include nav.php so that the user can go to the other pages if they desire

in sql User_123 has successfully logged on to the database in the past, but today he receives an error message stating that he cannot log on. What is the most likely cause of the problem?           Select one: a. User_123's CREATE USER privilege has been revoked. b. User_123 's CREATE SESSION privilege has been revoked.  c.  User_123's user account has been removed from the database. d. One or more object privileges have been REVOKEd from User_123 .

If you do not know the location of the update.txt file on your computer, print a copy.

• Open MS Access, Select New, type Northwind on the search field, double click to open Northwind database.After the Northwind 2007 is launched as shown below please answer the following questions in a note pad file named “surname student#”.Note: the Northwind sample database in an older version of MS Access is very different from the one in MS Access 2007 or higher )1. What version of Access do you have?2. Choose Object Type on the Navigation Pane. Please list different objects or components available in the Northwind Database window? Describe FIVE of them in simple words in terms of their functions.33. In the TABLE Shippers, how many shippers are there? Please list them.4. In TABLE Orders, which field (i.e. column heading) is identical to the field inTABLE Employees? and TABLE Customers? and TABLE Shippers? Please list all you can find in the format like Orders.field1=Employees.field2, and etc. (Clarification: consider the identity in terms of contents but not the field names, and…

If you are unsure of the location of the update.txt file on your computer, print one copy.

Instructions Create a Login/Registration From that is able to accept a Username/Emailadd and a Password.   Design a Database for the Login and Registration process. Provide at least 2 records that are pre-registered. Apply animation to your form.   Requirements to be submitted:    a. A snapshot picture of your running webpage.    b. A snapshot picture of your database with at least 2 record stored    c. Attach all your code in a document file to be uploaded with the images.     Software use CSS and HTML

Q1.True or false? For indexed sequential access the primary key field must contain unique key values for each record.

Use file permissions along with the  chown, chmod, and  chgrp commands to create a couple of folders: Create a directory (mkdir command) inside your home directory and set the permissions using the symbolic mode of chmod. The directory should be named dir1 and both you and the group cs260 should be able get into the directory and read from files. Only you should be able to write to the directory and no one other than you and the cs260 group should be able to access these files in any way. Create a file in this directory and put your name in it. Log in as Tess or Jessie and show that you can see the contents of the file. Save screenshots of both your commands to set up the folder, a listing of your home directory that shows the folder’s permissions, and you logged in as jesse/tess along with the contents of the file printed out on the screen (use vi or cat for this) Create a directory inside your home directory that both you and the cs260 group have full permissions on. No one else…

Use file permissions along with the  chown, chmod, and  chgrp commands to create a couple of folders: Create a directory (mkdir command) inside your home directory and set the permissions using the symbolic mode of chmod. The directory should be named dir1 and both you and the group cs260 should be able get into the directory and read from files. Only you should be able to write to the directory and no one other than you and the cs260 group should be able to access these files in any way. Create a file in this directory and put your name in it. Log in as Tess or Jessie and show that you can see the contents of the file. Save screenshots of both your commands to set up the folder, a listing of your home directory that shows the folder’s permissions, and you logged in as jesse/tess along with the contents of the file printed out on the screen (use vi or cat for this) Create a directory inside your home directory that both you and the cs260 group have full permissions on. No one else…

If you are unsure of the location of the update.txt file on your computer, print a copy.