Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Again, note that you will discuss specific activities that each of these roles may perform on a data analytics project that you select.
Identify the key determinants that could affect the degree of normalization of a database. Justify your response.
What are the business costs or risks of poof data quality? What is data mining? Support your discussion with at least 3 references.
Identify the number of days that exist between the first invoice. Construct a query that will show distinct area codes of the customers.
Evaluate at least two methods that can be used to optimize database components such as queries, reports SQL transaction processing, and data consumption.
Summarize the purpose of each system database. In your opinion, which is the most critical? What could happen if one of these is missing?
Analyze how switching to a more dynamic database will give Falcon Security a competitive advantage.
Draw the ER diagram map the ER diagram to 3NF and Normalisation. Identify the business situation that you wish to design a database for.
What is Data Governance? How is it important at enterprises-level? Implementing Data governance at Data Lakes? Pros, cons? Challenges?
Discuss the different types of information represented in the ER diagram and the symbols used to represent them. How would you approach the diagramming process?
Identify and create an Entity-Relationship (E-R) Diagram relating the tables of the database schema through the use of graphical tools in Microsoft Visio.
Explain why twisting improves the performance of network cabling. List the four main benefits of optical cable, when compared with metallic cable (100 words).
What kinds of questions might you be able to ask with the data on hand that will be relevant to Adventure Works?
HIT234- Identify business situation that you wish to design a database for. The situation needs to a real life one and ideally be something you are interested.
Draw an ER diagram for your proposed database. You need to show attributes, primary keys, and relationships (needs to use Chen and Crows feet notation).
Prepare an example on how time-variant data can be properly captured and maintained within a database system.
Describe the data structure that will store all data elements. Note: The graphically depicted solution is not included in the required page length.
Identify primary keys and foreign keys, and explain how referential integrity will be achieved. Normalize the database tables to third normal form (3NF).
Explain an opportunity in which Big Data can be used to make organization improvements. Identify appropriate challenges that might exist in using this data.
Identify an opportunity in which Big Data can be used to make organization improvements. Identify appropriate challenges that might exist in using this data.
NVivo and Atlas are two well-known data analysis tools described in the textbook. Determine which tool you prefer over the other and explain why.
Describe each of the normalizations and explain why the goal is 4NF. Do you think it is possible to create a database that maintains the rules of 4NF?
How a system could improve efficiency? How a system could improve accuracy? How sales of individual items would be entered?
Analyze in 500 words or more why Oracle 12c has introduced two new roles - AUDIT_ADMIN and AUDIT_VIEWER. Include a discussion of what database auditing is?
CISC520- n 1960s, statistician Mosteller and Wallace analyzed frequency distributions of common function words in Federalist Papers, and drew their conclusions.