1. Define data dependency, and explain only two reasons why this is undesirable. Explain the solution...
1. Define data dependency, and explain only two reasons why this is undesirable. Explain the solution to this.
2. One of the advantages of a database management system is to provide data independence. Explain this.
Homework Answers
1. Data dependency means that one/more attribute uniquely identifies other attributes of a relation. in more simple terms we can say that some data values are dependent on other data values in order to get recognized.
This situation is not desirable because every non-key attribute has to be fully dependent on the PK.
2. One of the highest advantage of databases is data independence. It means we can change the conceptual schema at one level without affecting the data at another level. It also means we can change the structure of a database without affecting the data required by users and programs.
Add Answer to:
1. Define data dependency, and explain only two reasons why this
is undesirable. Explain the solution...
1. a. Explain why the functional dependency with the primary key as the determinant and all...
1. a. Explain why the functional dependency with the primary key as the determinant and all non-key attributes as dependents is present in any relation. b. List reasons why we may have a relational model with data redundancy.
1. name and explain two reasons why employees resist change? 2. define the proactive personality? 3....
1. name and explain two reasons why employees resist change? 2. define the proactive personality? 3. define the term glass ceiling? 4. explain the consequences of stress to corporation? 5. why should employees be given an appeals process?
1- what are the stages for designing a database and explain them? 2- what is 3-layer...
1- what are the stages for designing a database and explain them? 2- what is 3-layer ANSI-SPARC architecture, explain 3 advantages of it, and how does this architecture address the issue of data independence for a database system? 3- (a)what is the definition of Normalization ? (b)why we use it? (c) how does normalization assist in or reducing redundancie on a design database?
1. what is the purpose of a performance appraisal? 2. name and explain two reasons why...
1. what is the purpose of a performance appraisal? 2. name and explain two reasons why employees resist change? 3. define the proactive personality? 4. define the term glass ceiling? 5. explain the consequences of stress to corporation? 6. why should employees be given an appeals process?
System Architecture 1--> What are the reasons why computers represent data using binary 2-->Explain why IT...
System Architecture 1--> What are the reasons why computers represent data using binary 2-->Explain why IT or IS professional needs to understand system architecture give a specific example of the type of knowledge that is needed and how they will use that knowledge in their career 3--> An ___________ is a signal or command to a processor to perform one of its functions 4---> An ________________ is a related group of primitive data elements organized for processing
1. Explain two reasons why it is important to have a working knowledge of DFDs and...
1. Explain two reasons why it is important to have a working knowledge of DFDs and flowcharting. 2. What does the Sarbanes-Oxley Act require that is relevant to documentation tools? 3. Describe a situation in which data flow should be shown with two data flow lines instead of one. 4. Describe the different levels of DFDs.
1. Define inventory and explain TWO (2) main objectives of inventory management 2. Identify FIVE (5)...
1. Define inventory and explain TWO (2) main objectives of inventory management 2. Identify FIVE (5) requirements of Dependent Inventory Model 3. Analyse TWO (2) components of Material Requirement Planning 4. Define planning phase in managing a project 5. State THREE (3) roles of a project manager. 6. State FIVE (5) specific requirements of an effective Material Requirement Planning 7. Define quality and State THREE (3) reasons why quality is important 8. Explain TWO (2) methods in manage of inventory...
An internal auditor should have a sound understanding of basic data processing concepts such as data...
An internal auditor should have a sound understanding of basic data processing concepts such as data organization and storage in order to adequately evaluate systems and make use of retrieval software. Define the following terms as used in a data processing environment (all are nouns): (1) field, (2) record, and (3) file. (1) Define a database. (2) List two advantages and two disadvantages of a database system. (CIA adapted)
2. Define estuary. What are two stresses placed on organisms that reasons why estuaries are important...
2. Define estuary. What are two stresses placed on organisms that reasons why estuaries are important and should be protected. (5) live in estuaries? Give four
1. Define and describe an enterprise system and explain how enterprise software works. 2. Define and...
1. Define and describe an enterprise system and explain how enterprise software works. 2. Define and describe customer relationship management and explain why customer relationships are so important today. 3. Describe the capabilities of customer relationship management software for sales, marketing, and customer service.
1. Explain two reasons why it is important to have a working knowledge of DFDs and flowcharting. 2. What does the Sarbanes-Oxley Act require that is relevant to documentation tools? 3. Describe a situation in which data flow should be shown with two data flow lines instead of one. 4. Describe the different levels of DFDs.
2. Define estuary. What are two stresses placed on organisms that reasons why estuaries are important and should be protected. (5) live in estuaries? Give four
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago