Search & Filtering
Databases | SQL | Oracle | MS Access
Instructions:
For each question, create a SQL query that answers the question and export the query results as a CSV.
Include all of your queries on a separate worksheet in the Excel file, paste each query into its own column and use the first row of the column to ID the query.
Don’t wait until Thursday if you have problems, contact me!
Questions — 50 points total:
1. How many votes had 0 “no” votes? 13 points
2. How many votes had a margin of less than 3 votes? 13 points
3. How many times did each result occur? 13 points
4. How many motions to table got more than 10 Republican “no” votes AND more than 10 Democratic “no” votes? 7 points
5. What was the result of all cloture votes, and how many times did each result occur? 4 points
Bonus: For question 4, for any rejected votes, what was is/are the title of the related bill or bills? 5 points.
For each question, create a SQL query that answers the question and export the query results as a CSV.
Include all of your queries on a separate worksheet in the Excel file, paste each query into its own column and use the first row of the column to ID the query.
Don’t wait until Thursday if you have problems, contact me!
Questions — 50 points total:
1. How many votes had 0 “no” votes? 13 points
2. How many votes had a margin of less than 3 votes? 13 points
3. How many times did each result occur? 13 points
4. How many motions to table got more than 10 Republican “no” votes AND more than 10 Democratic “no” votes? 7 points
5. What was the result of all cloture votes, and how many times did each result occur? 4 points
Bonus: For question 4, for any rejected votes, what was is/are the title of the related bill or bills? 5 points.
Databases | SQL | Oracle | MS Access
Confidentiality, integrity, and availability are the three common security goals. Select at least three security vulnerabilities that could jeopardize and compromise a database. Classify each vulnerability with being technical, managerial, cultural, or procedural. Provide your rationale.
Suggest specific actions that could be performed to minimize the vulnerabilities identified in Question 1 of this discussion. Describe how often these measures should be performed and the order in which each should be performed.
Suggest specific actions that could be performed to minimize the vulnerabilities identified in Question 1 of this discussion. Describe how often these measures should be performed and the order in which each should be performed.
Databases | SQL | Oracle | MS Access
Write a DBA statements to perform the following operations:(after each statement show the result of your work on database.)
A) Create user sameer. Assign him a password of HAITHAM and require that sameer change his password the next time he logs on.
B)create a table in the schema of sameer.
C)create user sami assign him the password dana.
D) connect as sameer and give sami the ability to select from sameer's CUSTOMERS table.Also, enable sami to give the select capability to other users.
E) remove from sami the ability to select from sameer'customer table.
f)Create a role called danger, which enables the user called sami to create a table, create a view
A) Create user sameer. Assign him a password of HAITHAM and require that sameer change his password the next time he logs on.
B)create a table in the schema of sameer.
C)create user sami assign him the password dana.
D) connect as sameer and give sami the ability to select from sameer's CUSTOMERS table.Also, enable sami to give the select capability to other users.
E) remove from sami the ability to select from sameer'customer table.
f)Create a role called danger, which enables the user called sami to create a table, create a view
Databases | SQL | Oracle | MS Access
by oracle sql*plus
2- a range-based partitioning table named p_student with attributes empno,empname,job,salary,department no. Make sure that the data entry of the each department goes to its own provided tablespaces such as the cs department goes to the dept10ts tablespace, the data entry of the cis department goes to the dept20ts tablespace, OTHERS goes to other_dept tablespace. specify the storage size parameter .
3- have the parallel query option, then the fastest method to create a table that has the same columns as the p_STUDENT table, but only for those student in department CS.
2- a range-based partitioning table named p_student with attributes empno,empname,job,salary,department no. Make sure that the data entry of the each department goes to its own provided tablespaces such as the cs department goes to the dept10ts tablespace, the data entry of the cis department goes to the dept20ts tablespace, OTHERS goes to other_dept tablespace. specify the storage size parameter .
3- have the parallel query option, then the fastest method to create a table that has the same columns as the p_STUDENT table, but only for those student in department CS.
Databases | SQL | Oracle | MS Access
by oracle sql*plus
1- Creating Sequences.
a. Connect as the DBA. Create a sequence named VENDOR_SEQUENCE that starts with the value 1 and is incremented by 1. Set the values for MINVALUE = 1 and MAXVALUE = 99999. Allow the sequence to CYCLE automatically and allocate NOCACHE as a sequence option.
b. Attempt to SELECT a value from the VENDOR_SEQUENCE by using the DUAL table in your SELECT command.
1- Creating Sequences.
a. Connect as the DBA. Create a sequence named VENDOR_SEQUENCE that starts with the value 1 and is incremented by 1. Set the values for MINVALUE = 1 and MAXVALUE = 99999. Allow the sequence to CYCLE automatically and allocate NOCACHE as a sequence option.
b. Attempt to SELECT a value from the VENDOR_SEQUENCE by using the DUAL table in your SELECT command.
Databases | SQL | Oracle | MS Access
While populating the table that stores the Issue/Return details with the sample data, you find that: The ItemID field should contain unique IDs. The values stored in the Tariff, AmountPaid and Balance fields should not be less than 0. Alter the corresponding table to add constraints so that the preceding requirements can be implemented
Databases | SQL | Oracle | MS Access
the relational algebra is a _____ query language
a. maths
b. procedural.
c. non-procedural
d. calculation
a. maths
b. procedural.
c. non-procedural
d. calculation
Databases | SQL | Oracle | MS Access
What are web cookies and what are they used for?
What is different in (a) network routing and (b) the web server between these two URLs:
http://sub.domain.org/
and
http://domain.org/sub/?
Given examples of possible relationships in a database, tell me their types, for example in a database of university students and their enrolments: the relationship between students and classes would be many-to-many.
What is different in (a) network routing and (b) the web server between these two URLs:
http://sub.domain.org/
and
http://domain.org/sub/?
Given examples of possible relationships in a database, tell me their types, for example in a database of university students and their enrolments: the relationship between students and classes would be many-to-many.
Databases | SQL | Oracle | MS Access
how to write criteria to establish a summary of one month of information in MS Access
Databases | SQL | Oracle | MS Access
Using the relations that you have defined for the library system, normalize your relations into first, second, and third normal form. Your output should be an Entity Relationship diagram that is in 3NF. All attributes, entities, keys, and relationships should be included and labeled. Although you do not need to include an ER diagram (unless you want to) for the relations in 1st normal form or 2nd normal form, you must describe the changes required to your relations to meet the standard of first 1st normal form and then 2nd normal form and of course 3rd normal form.
Assignment Instructions:
•the assignment must define or describe the changes required to get the relations into the 1st normal form
•the assignment must define or describe the changes required to get the relations into the 2nd normal form
•the assignment should include an Entity Relationship diagram that details each of the following relations and their attributes in 3rd normal form.◦Book
◦Borrower
◦BookLended
◦Librarian
Assignment Instructions:
•the assignment must define or describe the changes required to get the relations into the 1st normal form
•the assignment must define or describe the changes required to get the relations into the 2nd normal form
•the assignment should include an Entity Relationship diagram that details each of the following relations and their attributes in 3rd normal form.◦Book
◦Borrower
◦BookLended
◦Librarian
