Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
CLEARLY explain (1) what structured design means, (2) its major benefits and (3) how it applies to DATAL's network (6 lines MAX).
Add criteria to the AttendeeFirstName query to select only those records where the FirstName field value begins with Lau followed by any other letters.
Determine Coca Cola strategic in marketing: customer segments in the market and the target customer group that the company focused on.
What are Data warehousing and Data minings? Is it an internal and external source ?. and how can they help in gathering secondary data?
Create object called stock price which is initially equal to 100. Use loop to find how many days it takes before price of stock is greater than 150 or below 50.
How will the report user benefit from the information in the report? How might you extend the report to make it more useful?
What factors are important in a DBMS software selection? What are the advantages and disadvantages when an organization contains single vs multiple databases?
Discuss the importance and characteristics of database backup and recovery procedures. Then describe actions that must be detailed in backup and recovery plans.
Define the entities, attributes, and relations that exist between them. Create a logical model using crow's feet notation in Visio.
Create a store procedure (LastNameSEL) that receives the first name of the employee from the Employees table as input produce the last name as output.
Draw a PATIENT entity with attributes. Specify all attribute types. Draw a DOCTOR entity with attributes. Specify all attribute types.
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?