Homework Answers
Ques 1. Answer : column
An attribute is a property or a characteristic of a particular field. It represents the data which has the same property.
Also, in a spreadsheet, the same type of data is stord in the same column.
e.g: name is an attribute. We store the names of different people into same column.
Ques 2. Answer : (a) conceptual
They should first begin with a concept on what the requirements are and how it is to be modelled. So, first a conceptual model is build and then a relational model is build.
Que 3. Answer : (a) redundancy
Redundancy is the state in which there are multiple copies of same data. This is a big problem in database an a good database is one which has no redundancy at all. So, the states 1NF, 2NF, 3NF aim to reduce the redundancy.
Add Answer to:
An attribute in a data model is the same as a(n) in a table or spreadsheet....
6. With respect to database systems, which of the following statement(s) is (are) true? a. The...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....
The previous report is the only supporting document a contracting company has provided for getting a...
The previous report is the only supporting document a
contracting company has provided for getting a new database design.
As the company’s owner is very busy, he has requested you to
generate a set of suitable relations with the report above.
The process you will follow is itemized below, be brief but provide
a good explanation when asked:
1. Considering Employee 112, in how many projects do you find him?
What does it tell you in relation to employees? (7...
(Data base Management) Our company allows each sales representative to place sales orders (SOs) for customers,...
(Data base Management) Our company allows each sales representative to place sales orders (SOs) for customers, for items that they may need. The company refers to “items” and “products” as the same thing, as we are a service provider and do not produce any physical “product” that we sell, outright. Consider the following SO (Sales Order) table: Attribute Sample Sample Sample Sample Sample Sample SALES_ORDER_NUM 211345 211345 211345 211346 211347 211348 SALES_ORDER_LINE_NUM 1 2 3 1 1 1 SALE_DATE 15-Oct-15...
The lab for this week addresses taking a logical database design (data model) and transforming it...
The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model (tables, constraints, and relationships). As part of the lab, you will need to download the zip file titled CIS336Lab3Files from Doc Sharing. This zip file contains the ERD, Data Dictionary, and test data for the tables you create as you complete this exercise. Your job will be to use the ERD Diagram found below as a guide to define the...
Discussion questions 1. What is the link between internal marketing and service quality in the ai...
Discussion questions
1. What is the link between internal marketing and service
quality in the airline industry?
2. What internal marketing programmes could British Airways
put into place to avoid further internal unrest? What potential is
there to extend auch programmes to external partners?
3. What challenges may BA face in implementing an internal
marketing programme to deliver value to its customers?
(1981)ǐn the context ofbank marketing ths theme has bon pururd by other, nashri oriented towards the identification of...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....
The previous report is the only supporting document a
contracting company has provided for getting a new database design.
As the company’s owner is very busy, he has requested you to
generate a set of suitable relations with the report above.
The process you will follow is itemized below, be brief but provide
a good explanation when asked:
1. Considering Employee 112, in how many projects do you find him?
What does it tell you in relation to employees? (7...
The lab for this week addresses taking a logical database design (data model) and transforming it into a physical model (tables, constraints, and relationships). As part of the lab, you will need to download the zip file titled CIS336Lab3Files from Doc Sharing. This zip file contains the ERD, Data Dictionary, and test data for the tables you create as you complete this exercise. Your job will be to use the ERD Diagram found below as a guide to define the...
Discussion questions
1. What is the link between internal marketing and service
quality in the airline industry?
2. What internal marketing programmes could British Airways
put into place to avoid further internal unrest? What potential is
there to extend auch programmes to external partners?
3. What challenges may BA face in implementing an internal
marketing programme to deliver value to its customers?
(1981)ǐn the context ofbank marketing ths theme has bon pururd by other, nashri oriented towards the identification of...
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