Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Which two are best in collecting information to improve database process. Explain what they are are and how they best improve the process.
Find every flight for which there are no flight legs listed in the database. Find the flight(s) that have the highest fare(s).
Implement a new strong entity phone in the Sakila database. Attributes and relationships are shown in the following diagram:
Write a query to display the following information for the products, which have not been sold: product_id, product_desc, product_quantity_avail, product_price.
What do you think the most realistic method of testing the plan should be? Should all of these people be involved?
Which of the academic writing resources do you think would be most helpful to you? Why? How might you use these resources with students that you might teach?
Would a SIEM system be valuable if it did not normalize data? Why or why not? Does an organization that uses a SIEM system still need a human analyst?
Describe what QBE means in a database. Provide an example of one that is different from the ones used in the course walk database.
Explain why database design is important. Discuss the importance of data modeling. User specifications - gathering information during the design process.
What is the Configuration Management Database (CMDB)? Why is the CMDB important and how is it used? What is the service catalog?
Discuss a business or organization that may store your data in a database and describe why you think that is useful to that business to do so.
What would be the strengths and weaknesses of building a database application using a relational database vs. using a spreadsheet?
Define the importance of ontologies for unstructured data warehouses. Provide an example of unstructured data and the use of an ontology used to manage this dat
When and why do we need to use a compound primary key? What are entity relationships? What role do they play in database design?
How does this foreign key relationship show in entity framework? In other words, do we use foreign keys in Entity Framework?
What do you think is one good use case for advanced data visualizations such as choropleth charts, interactive web-based data visualizations, or network graphs?
How do you think data governance impacts the processes used to handle data in an organization?
Write SELECT statement that returns two columns based on the Customers table. The first column, ContactName, is the customer's name in this format.
Identify at least three policies you believe need to be understood when conducting an investigation involving cloud storage.
How would you encrypt and send data from a database to a submarine via a satellite? (Wants me to talk about symmetric and asymmetric encryption/decryption).
Write a query against the Sales. Orders table that returns OrderID, Year, Month and Day for the orders placed in June 2013.
Now assuming the customer wants to limit route advertisement to ISP 1 and ISP 3 to only the routes. Design and implement a way to do so on R2.
How did/could your selected technology change affect data management practices? Were the impacts positive, negative, or both?
Discuss how better Data management improve each company's business performance. Also, provide examples of two decisions that were improved by mining these custo
Show some examples of each based on the definition of Data Structures and Numerical data? What are some fundamental principles in creating a SELECT query?