WEEK 11 ASSIGNMENT
.docx
keyboard_arrow_up
School
Bellevue University *
*We aren’t endorsed by this school
Course
605
Subject
Computer Science
Date
May 14, 2024
Type
docx
Pages
5
Uploaded by Manojmanu7 on coursehero.com
1
CIS605-T301 Advanced Database Management (2241-1)
PROFESSOR: Dr. Nicki Susman
WEEK 11 ASSIGNMENT NAME: RAHITHYA KILARU
STUDENT ID: 21400585
November 12, 2023
2
YOU ARE TO USE SQL COMMANDS TO BUILD THESE UNLESS OTHERWISE NOTED.
1. Use SSMS (not T-SQL) to configure a replication. On the final page, check the box to
generate a script file.
Capture the script file path and paste it into your assignment document.
Select the report at the end of the process and copy/paste the report content into your
assignment document.
*****
2. Use SSMS (not T-SQL) to create a job and steps. The job name will be backup. Set up the
appropriate T-SQL command steps to backup the cis605 database. Copy and paste the T-SQL
statements you place in the command steps into your assignment solution. In the advance option,
create a T-SQL script that will output to a file. List the steps you take to accomplish this action in
your solution document.
3
1.
Begin by launching SQL Server Agent and navigating to the SQL Server Agent node in SQL
Server Management Studio.
2.
Right-click to initiate the creation of a new job. Assign the name "BACKUP" to the job.
3.
Opt for "STEP" from the left menu and set up the step name as "BACKUP." Choose the
database as "CIS605" and write the T-SQL command to execute the stored procedure
responsible for backing up CIS605.
4.
To enhance the configuration, select the Advanced option and specify an output file.
*****
3. Use SSMS (not T-SQL) to create a schedule for the backup job you created in problem 2. *****
4. Use SSMS (not T-SQL) to create a replication distribution for the cis605 database. Set to
snapshot, create the publication and generate a script file with steps to create the publication. View the report when the publication is successfully run and copy/paste it into your
assignment solution. Locate the publication SQL file you created, copy/paste the publication SQL
statements into your assignment solution.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Tahaghoghi, 2006).
?
Assessment Task
1. You are creating a database named NewDB. The database uses the server's
default character. What SQL statement should you use to create the database?
2. You are creating a table in a MySQL database from previous number. The table is
named Bikes and includes two columns: BikelD and BikeName. The BikelD
column must uniquely identify each row in the table, and values must be
automatically assigned to each row. The BikeName column must include a
descriptive name for each model of bike. The names vary in length but should
never exceed 40 characters. What SQL statement should you use to create the
table?
3. Write a SQL statement to insert the given data into the table countries against each
column.
Id
Country
Malaysia
2
Thailand
3
Mongolia
4
Georgia
5
Turkmenistan
95
6
Philippines
7
Israel
Here in the following is the structure of the table "countries".
| Field
| Туре
| Null | Key | Default | Extra |
| varchar(2)
| COUNTRY_ID
| COUNTRY_NAME |…
arrow_forward
Consider a database with the following
tables:
Patient(PatientID. PatientName,
NumberOfVisits) / Doctor(DoctorID.
DoctorName) Appointment(AppID.
DoctoriD, PatientID. Date, time)
1.Write SQL statement to execute the view
AppointmentsView
arrow_forward
.Considered the tables structures that you need in this question are the same of DBS311 database :
Display the highest, lowest, and average customer credit limits. Name these results high, low, and average. Add a column that shows the number of no credit records named “Invalid credit”. Display the result of the average as integer.
arrow_forward
DATABASE
Given the structure and contents of the StartAPPCo database , answer the following questions.
1. Given the information above, create the StartAPPCo database.
2. Write SQL code to insert data into all the tables created.
arrow_forward
Complete the Performing SQL Injection to Manipulate Tables in a Database lab which is located on Infosec Learning's website. Follow the instructions for the lab and export your performance report. When you have completed the lab, attach your performance report by clicking on the title of this assignment and submit it for grading. You are required to submit the following deliverable for grading: Performing SQL Injection to Manipulate Tables in a Database.
arrow_forward
SQL Queries
Specify the following SQLite queries on the chinook database. A schema for the database is in the picture.
You can access the database online through your web browser at the SQLite Tutorial, or you can download the chinook.db database from the tutorial site and run it on a labnet machine or your own machine. SQLite is already installed on labnet machines.
You must submit typed queries, not handwritten ones, and save them in a .pdf document. There is no need to submit the output (results).
Each query is worth 1 mark, but some are more difficult than others.
Queries to Specify
5. List the customer id, last name and email address of all customers with a Yahoo or Hotmail email address.
6. List the album id and number of tracks for all albums with 15, 16 or 17 tracks, in descending order of the number of tracks.
7. Find the maximum track length in milliseconds.
8. List the last name, first name and hire date of all employees born in 1961 to 1969 inclusive
9. List the…
arrow_forward
Computer Science
Table student with the attribute’s student_Id, Fname, Lnameme, Date of Birth, Address, and GPA is included in the registration database.
1. Create the above table using the SQL command.
2. Insert 6 records into the student table using SQL command.
3. Write a PHP code to connect to the database called “registration”, that contains the student table.
4. Write a PHP code to retrieve all students with GPA between (2.5 and 4.0 ) from the student's table and display them as a list that contains: student_Id, Fname, Lname, Address, and GPA on the screen.
5. Write a PHP code to delete students with GPA between 1 and 1.99.
arrow_forward
SQL Queries
Specify the following SQLite queries on the chinook database. A schema for the database is in the picture.
You can access the database online through your web browser at the SQLite Tutorial, or you can download the chinook.db database from the tutorial site and run it on a labnet machine or your own machine. SQLite is already installed on labnet machines.
You must submit typed queries, not handwritten ones, and save them in a .pdf document. There is no need to submit the output (results).
Each query is worth 1 mark, but some are more difficult than others.
Queries to Specify
1. List the last name, postal code and country for all customers from Germany.
2. List the city and number of customers from each city.
3. List the customer id, last name and city for the first 20 customers, when they are ordered by last name ascending.
4. List the customer id, last name and company for all customers who have any company details recorded (the company attribute is not "null").…
arrow_forward
25-Create a SQL statement/s to Add/insert the following records in the CLIENTS table:
CLIENTS
CID
CName
Gender
Address
Contact
CType
1521
Ahmed Said
Male
SLL
92214561
Old
1522
Salma Mohammed
Female
MCT
92384792
New
1523
Faiza Ahmed
Female
SLL
97451382
Old
1524
Noaman Said
Male
NZW
New
arrow_forward
e11] - Read-Only - Word
References
Mailings
Review
View
Help
28 - in my SQL with innoDB how are the primary and secondary indexes created?
a) primary indexes are automatically created for each primary key. Secondary indexes are created
manually for the foreign keys.
b) primary indexes are manually created for each primary keys. All the secondary indexes are
created automatically.
c) primary indexes are automatically created for primary key secondary indexes are created
automatically for the foreign keys.
d) Primary indexes are manually created for each primary key secondary index are men created
manually for each foreign key.
structure while those without a
29 - in MYSQL with innoBD with the primary key however
primary key have a
structure.
a) Неар, sorted.
b) Sorted, heap.
c) Sorted, hash.
d) Cluster, heap
30 - what approach in a database administrator used to assess the effectiveness of indexes while
investigating slow queries?
a) Run EXPLAIN on queries
b) Change the primary key.
c)…
arrow_forward
25-
Create a SQL statement/s to insert the following records in the CLIENTS table:
CLIENTS
CID
CName
Gender
Address
Contact
CType
1521
Ahmed Said
Male
SLL
92214561
Old
1522
Salma Mohammed
Female
MCT
92384792
New
1523
Faiza Ahmed
Female
SLL
97451382
Old
1524
Noaman Said
Male
NZW
New
arrow_forward
Create a user etec224. (Screenshot 1)
Create a database Bank. (Screenshot 2)
Grant etec224 privileges to Bank(Screenshot 3)
As etec 224, create a table customers with the following structure. (Screenshot 4)
CustomerID int(12)
Primary Key and not null
AccountNo int(12)
FirstName varchar(15)
not null
LastName varchar(15) not null
Birthday datetime
Balance double(10,2)
use a command to describe the table(Screenshot 5)
insert 3 customers randomly to the above table(Screenshot 6)
show all the contents of the table. (Screenshot 7)
Were you able to complete the commands?
True
False
arrow_forward
Execute the following statements using MYSQL:
1. Insert a row with the values (005, "Your name",
, "Your Dept", 50000, 40)
2. Create a trigger (model trigger) to ensure that no employee of salary less than
20000 can be inserted in the database. Show the result for your trigger
condition by inserting a new row.
arrow_forward
: write the steps to design new database file as (subjtable1.dbf) that consists .(of (2) fields: subj-nbr n(2), subj-name c(20 Q2: write the steps to design new form as (frm1.scx) from table in (Q1) with .command for closing form
arrow_forward
MYSQL DBMS
Consider the DVD Rental database named Sakila from the MYSQL examples.
a) Write a query that returns the names of movies in descending order of times they
were rented. Present the result obtained from the first films.
b) Show the execution plan available in MYSQL and use the EXPLAIN command.
Analyze and comment on the results.
arrow_forward
IN MYSQL
in DBA oracel
Create a user with the name IS Sead and password a789 and give him permission to connect to the databaseCreate a role function that includes allowing to create a table and create a view and then granting that function to the Sead . user
Make the sead user give permission to query and enter on the student table for all users in the databaseHave the user sead withdraw the entry on the student table from user saa
arrow_forward
Considered the tables structures that you need in this question are the same of DBS311 database :
Display the highest, lowest, and average customer credit limits. Name these results high, low, and average. Add a column that shows the number of no credit records named "Invalid credit". Display the result of the average as integer.
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
BI U S
Paragraph
A v
In
x X2
Arial
10pt
...
arrow_forward
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.
arrow_forward
Q2/ write SQL commands to create tables of a Bank database,
where these tables will have the following schemas:
branch(branch_ name, branch_city, assets)
customer(customer_name, customer_street, customer_city)
loan(loan number, branch_name, amount)
arrow_forward
Q2/ write SQL commands to create tables of a Bank database,
where these tables will have the following schemas:
branch(branch_name, branch_city, assets)
customer(customer name, customer_street, customer_city)
loan(loan_number, branch_name, amount)
arrow_forward
SBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name
use the following statement to Write the MongoDB Shell code to completely delete the entire database, including all collections and documents
arrow_forward
MYASQL
7. Create Avgoffreight() stored procedure to retrieve the average of freight from Orders table. Then , show the result.8. Write a database trigger TO insert the UnitPrice field.IF UnitPrice is less than 10 then make it equal to 10.(BEFORE INSERT). Test the trigger and show its result.procedure and trigger9. Select the first 10 characters of each customer's address. (Hint: You can use one of the built-in functions that are explained in functions file). (bonus, if you want to get higher mark, you can answer it, if not ,you can upload the solution file without it )
arrow_forward
PL/SQL Problems
Q1. Create a function to calculate a shopper’s total spending, excluding shipping and tax amount, with Brewbean’s site in a particular year. Exception handling is needed.
Use an anonymous block to call the function and output the result.
Q2.Create a procedure to allow an employee in the shipping department to update an order status to add shipping information. The BB_BASKETSTATUS table lists events for each order so that a shopper can see the current status, date, and comments as each stage of the order process are finished.
Use an anonymous block to test your procedure.
Q3.Create a function to insert a new product into an existing order, include the product id, unit price, quantity. The output of the function is the message to notify the calling program whether the update succeeded or not.
Use an anonymous block to call the function and output the result.
Q4.Create a function to determine the total pledge amount for a project. Use the function in an SQL statement to…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
Related Questions
- Tahaghoghi, 2006). ? Assessment Task 1. You are creating a database named NewDB. The database uses the server's default character. What SQL statement should you use to create the database? 2. You are creating a table in a MySQL database from previous number. The table is named Bikes and includes two columns: BikelD and BikeName. The BikelD column must uniquely identify each row in the table, and values must be automatically assigned to each row. The BikeName column must include a descriptive name for each model of bike. The names vary in length but should never exceed 40 characters. What SQL statement should you use to create the table? 3. Write a SQL statement to insert the given data into the table countries against each column. Id Country Malaysia 2 Thailand 3 Mongolia 4 Georgia 5 Turkmenistan 95 6 Philippines 7 Israel Here in the following is the structure of the table "countries". | Field | Туре | Null | Key | Default | Extra | | varchar(2) | COUNTRY_ID | COUNTRY_NAME |…arrow_forwardConsider a database with the following tables: Patient(PatientID. PatientName, NumberOfVisits) / Doctor(DoctorID. DoctorName) Appointment(AppID. DoctoriD, PatientID. Date, time) 1.Write SQL statement to execute the view AppointmentsViewarrow_forward.Considered the tables structures that you need in this question are the same of DBS311 database : Display the highest, lowest, and average customer credit limits. Name these results high, low, and average. Add a column that shows the number of no credit records named “Invalid credit”. Display the result of the average as integer.arrow_forward
- DATABASE Given the structure and contents of the StartAPPCo database , answer the following questions. 1. Given the information above, create the StartAPPCo database. 2. Write SQL code to insert data into all the tables created.arrow_forwardComplete the Performing SQL Injection to Manipulate Tables in a Database lab which is located on Infosec Learning's website. Follow the instructions for the lab and export your performance report. When you have completed the lab, attach your performance report by clicking on the title of this assignment and submit it for grading. You are required to submit the following deliverable for grading: Performing SQL Injection to Manipulate Tables in a Database.arrow_forwardSQL Queries Specify the following SQLite queries on the chinook database. A schema for the database is in the picture. You can access the database online through your web browser at the SQLite Tutorial, or you can download the chinook.db database from the tutorial site and run it on a labnet machine or your own machine. SQLite is already installed on labnet machines. You must submit typed queries, not handwritten ones, and save them in a .pdf document. There is no need to submit the output (results). Each query is worth 1 mark, but some are more difficult than others. Queries to Specify 5. List the customer id, last name and email address of all customers with a Yahoo or Hotmail email address. 6. List the album id and number of tracks for all albums with 15, 16 or 17 tracks, in descending order of the number of tracks. 7. Find the maximum track length in milliseconds. 8. List the last name, first name and hire date of all employees born in 1961 to 1969 inclusive 9. List the…arrow_forward
- Computer Science Table student with the attribute’s student_Id, Fname, Lnameme, Date of Birth, Address, and GPA is included in the registration database. 1. Create the above table using the SQL command. 2. Insert 6 records into the student table using SQL command. 3. Write a PHP code to connect to the database called “registration”, that contains the student table. 4. Write a PHP code to retrieve all students with GPA between (2.5 and 4.0 ) from the student's table and display them as a list that contains: student_Id, Fname, Lname, Address, and GPA on the screen. 5. Write a PHP code to delete students with GPA between 1 and 1.99.arrow_forwardSQL Queries Specify the following SQLite queries on the chinook database. A schema for the database is in the picture. You can access the database online through your web browser at the SQLite Tutorial, or you can download the chinook.db database from the tutorial site and run it on a labnet machine or your own machine. SQLite is already installed on labnet machines. You must submit typed queries, not handwritten ones, and save them in a .pdf document. There is no need to submit the output (results). Each query is worth 1 mark, but some are more difficult than others. Queries to Specify 1. List the last name, postal code and country for all customers from Germany. 2. List the city and number of customers from each city. 3. List the customer id, last name and city for the first 20 customers, when they are ordered by last name ascending. 4. List the customer id, last name and company for all customers who have any company details recorded (the company attribute is not "null").…arrow_forward25-Create a SQL statement/s to Add/insert the following records in the CLIENTS table: CLIENTS CID CName Gender Address Contact CType 1521 Ahmed Said Male SLL 92214561 Old 1522 Salma Mohammed Female MCT 92384792 New 1523 Faiza Ahmed Female SLL 97451382 Old 1524 Noaman Said Male NZW Newarrow_forward
- e11] - Read-Only - Word References Mailings Review View Help 28 - in my SQL with innoDB how are the primary and secondary indexes created? a) primary indexes are automatically created for each primary key. Secondary indexes are created manually for the foreign keys. b) primary indexes are manually created for each primary keys. All the secondary indexes are created automatically. c) primary indexes are automatically created for primary key secondary indexes are created automatically for the foreign keys. d) Primary indexes are manually created for each primary key secondary index are men created manually for each foreign key. structure while those without a 29 - in MYSQL with innoBD with the primary key however primary key have a structure. a) Неар, sorted. b) Sorted, heap. c) Sorted, hash. d) Cluster, heap 30 - what approach in a database administrator used to assess the effectiveness of indexes while investigating slow queries? a) Run EXPLAIN on queries b) Change the primary key. c)…arrow_forward25- Create a SQL statement/s to insert the following records in the CLIENTS table: CLIENTS CID CName Gender Address Contact CType 1521 Ahmed Said Male SLL 92214561 Old 1522 Salma Mohammed Female MCT 92384792 New 1523 Faiza Ahmed Female SLL 97451382 Old 1524 Noaman Said Male NZW Newarrow_forwardCreate a user etec224. (Screenshot 1) Create a database Bank. (Screenshot 2) Grant etec224 privileges to Bank(Screenshot 3) As etec 224, create a table customers with the following structure. (Screenshot 4) CustomerID int(12) Primary Key and not null AccountNo int(12) FirstName varchar(15) not null LastName varchar(15) not null Birthday datetime Balance double(10,2) use a command to describe the table(Screenshot 5) insert 3 customers randomly to the above table(Screenshot 6) show all the contents of the table. (Screenshot 7) Were you able to complete the commands? True Falsearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrEnhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning