Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
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?
Write a brief paragraph of about 200 words discussing the following: Does your database design allow the storage of all the required information?
How can a database be more beneficial, versus a spreadsheet, in the gathering. What are some potential advantages a database has over a spreadsheet?
Write a query that displays all the rows from the War; table where the rows were modi?ed during the month of December in the year 2000.
Define and describe the components of an SQL database. Compare and contrast database server and database client software.
What would be the list of attributes to have in each entity? What would the primary and foreign keys be for each entity?
Problem: Discuss the limitations of enterprise data warehouses. Describe the benefits of a data lake to organizations.
Develop an entity relationship diagram for the Richmond Alternative Family Therapy. Express as many of the constraints in this scenario