Concept explainers
a.
Given scenario:
Here an organization has 1000 employees with seven different offices for which the report is to be created including the list of all the employees’ blogs, job titles and departments and the purpose of the employees and the URL of each blogs.
b.
Given scenario:
Here an organization has 1000 employees with seven different offices for which the report is to be created including the list of all the employees’ blogs, job titles and departments and the purpose of the employees and the URL of each blogs.
c.
Given scenario:
Here an organization has 1000 employees with seven different offices for which the report is to be created including the list of all the employees’ blogs, job titles and departments and the purpose of the employees and the URL of each blogs.
d.
Given scenario:
Here an organization has 1000 employees with seven different offices for which the report is to be created including the list of all the employees’ blogs, job titles and departments and the purpose of the employees and the URL of each blogs.
Want to see the full answer?
Check out a sample textbook solutionChapter AE Solutions
Using MIS (10th Edition)
- using the sakila databse, answer the following questions 1. Your professor wants you to find all the information related to the films whoserating is NOT R, has “dog” word mentioned in its description, and language is inEnglish. 2. Provide your professor the name of the movie titles (along with Inventory ID) whichare currently rented right now (and has not been returned by the customers). Pleasekeep in mind that, in the rental table, any movie rented out but not returned yet willhave NULL in the return_date attribute. 3. Based on given database, which Rating type (such as R, or PG or others) have thehighest total rental_duration in total (as given in film table).arrow_forwardConsider the data about students in your university's database as a huge table containing a row for each student and a column for each data element. Sort the data into main categories such as contact information, medical information, financial information, and academic information. Which employment categories should be accessible to which groups of people? Who should have access to a single row within a group, who should have access to multiple rows but not to all rows, and who should have access to all rows in the table? Should anyone have the ability to view data but not alter it?arrow_forwardStudy the scenario and complete the question(s) that follow: A vet clinic "XYZ Vets" has a website with registration and login pages for its clients. The registration form contains standard registration details such as client name and surname, phone number, email address and password. You have been asked to create the relevant SQL table. The data collected should be stored and validated such that only properly authenticated clients would be granted access to the vet appointment booking page. You are not required to create the vet appointment booking page. However, you are required to verify successful authentication. With the use of MYSQL: 4.1 Create a relevant SQL table for storing the data. 4.2 Store the registration details. 4.3 Authenticate clients. 4.4 Upon successful authentication of clients, display relevant client information with a personalised message.arrow_forward
- For a day, monitor your queries on a search engine. Suppose someone had access to those queries, knew they came from you, and knew your name. Might an analyst derive any wrong inferences about you from your queries?arrow_forwardConsider some of the benefits that data profiling has to offer.arrow_forwardCongratulations! You have been hired to plan databases for the European Union. Your first job assignment is to help the various countries maintain information about their inhabitants. Your model should capture the following information: - In each country, there are provinces, which contain towns. There cannot be two provinces with the same name in a single country. Similarly, there cannot be two towns with the same name in a single province. - People live in towns. Men and women work in a town. Children learn in a school in a town. - A person can be a man, a woman, or a child, and has a first-name, last-name, id, and birthday. Children are considered to be any people under the age of 18. - A man can be married to a woman (polygamy is not allowed, i.e., one man can be married only to one woman). Although the Pope strongly disapproves, divorce, and subsequent remarriage, is possible. - For each marriage, store the date of the marriage and information about who are the children of the…arrow_forward
- For the big university database table, list FDs with the column StdCity as the determinant that are falsified by sample rows. For each FD, you should identify one falsification example or indicate that no falsification example exists in the sample rows. Remember that it takes two rows to falsify an FD in which the LHS is the same in both rows but the RHS is different.arrow_forwardSuppose you are a judge trying to decide a dispute between a buyer and a supplier. The buyer claims not to have produced a particular email purchase order, while the supplier shows you the purchase order, and certificates and CRLs (Certificate Revocation Lists), demonstrating that the purchase order was signed by the buyer. All documents have been signed by a notary. How would the dates on the various pieces of evidence influence your decision? What if only the purchase order was signed by the notary?arrow_forwardThink about a student database with the StudentID as the main key and the Major, Age, MaritalStatus, and HomeZipCode indexes (all secondary keys). If the institution requested a list of MIS or computer science majors who were over 25, married, and from the 45462 zip code OR computer engineering majors who were single and from the 45462 zip code, then let's pretend they were both over 25 and from the 45462 postcode. How can indexes be used to guarantee that only the data that satisfies this criteria is accessible to users?arrow_forward
- Consider the data of the following two tables. Department DepartmentID DName ContactNo 1 UIIT 0300-1234567 2 UIMS 0300-4567891 Student RollNo Sname Fname DepartmentID 111 Ali Ahmed 1 112 Sana Waqar 2 113 Afzal Ikram 2 There are only two departments and are already initialized globally, but students can be upto 100 and just defined globally. To maintain how many student’s record have been entered you can use global variable with name as count. Write a C++ program having: Structures, structure definitions and required initializations for the above scenario. Function which takes input data (RollNo, Sname, Fname and DepartmentID) of student from user within the function, then verify that the DepartmentIDexists in Department or not? If exists then copy DName and ContactNo in the student record along with above input, otherwise just display a message that department does not exists. For example the following record…arrow_forwardDamon Davis was creating the Drano Plumbing Company's spreadsheet. He determined that the net income would be $50,000. When he tallied the columns on the Balance Sheet, the totals were as follows: debit, $400,000; and credit, $300,000. What was the most likely reason for this discrepancy? If this was not the case, how should he proceed to determine the source of the error?arrow_forwardcan you help me iwth these two queries in mySQL. Write a SQL statement to create a table job_history including columns employee_id, start_date, end_date, job_id and department_id and make sure that, the employee_id column does not contain any duplicate value at the time of insertion and the foreign key column job_id contain only those values which are exists in the jobs table. Write a SQL statement to create a table employees including columns employee_id, first_name, last_name, email, phone_number hire_date, job_id, salary, commission, manager_id and department_id and make sure that, the employee_id column does not contain any duplicate value at the time of insertion and the foreign key columns combined by department_id and manager_id columns contain only those unique combination values, which combinations are exists in the departments table.arrow_forward
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage