Homework Answers
Add Answer to:
Question #1 Consider the following Table All information have been placed in one table. Arrows show...
Fundamentals of Database Systems Consider the following data. Arrows show the functional dependency Product Item ld...
Fundamentals of Database Systems
Consider the following data. Arrows show the functional dependency Product Item ld QuantityItem Used uct Receipt Quantity Sales ription Number Num Description Date The arrows in this question indicated the determination of two attributes. For example, the arrow that goes ProductID to ProductDescription indicates that ProductID determines the ProductDescription, This in turn means that Productld can be considered as primary key for ProductDescription a) Write the tables b) Place the tables in 3rd normal form (if...
for question (c) do like this 3. A table to record the information of Dentists, Patients,...
for question (c) do like this
3. A table to record the information of Dentists, Patients, and Appointments in a clinic is given below. DentistNo DentistName PatientNo PatientName PatientPhone AppointmentDate Appointment Time AppointmentFee On a single day each patient can have more than one appointment. It is known that DentistNo is unique for each dentist. PatientNo is unique for each patient. PatientNo must not be used as a composite key. A patient is allowed to see any dentist. (a) Use...
2) Consider the following table of information Primary Key (CourselD, SemesterlD) CoursetD I Senester TD 1...
2) Consider the following table of information Primary Key (CourselD, SemesterlD) CoursetD I Senester TD 1 Places 1 Course Name IT101 1 2009-1 110I Programing IT1e1 I 2009-2 11e0 I Programming IT102 I 2009-11200 1 Databases IT102 I 2010-1 115I Databases IT103 2009-2 1120 I Web Design A. B. Normal Form Violation: Put into Sentence Structure: C. Normalized: 3) Consider the following: Primary Key ISBN ISBN Title Publisher Address A. B. Normal Form Violation: Put into Sentence Structure: C. Normalized:...
The employee is table, the best candidate for primary key is Select one: a. Department ID...
The employee is table, the best candidate for primary key is Select one: a. Department ID b. Employee hiredate c. Employee ID d. Employee salary Question 2 A primary key can be composed of more than one attribute. Select one: True False Question 3 A foreign key allows you to join two tables. Select one: True False Question 4 Given two tables, department (dept_id, dept_location, dept_name) and EMPLOYEE(emp_id, emp_name, emp_dept_id, emp_name, emp_salary), which attribute (column) is the foreign key? Select...
Please help me answer the following questions regarding data relationship tables. Employee ID First Name Last...
Please help me answer the following questions regarding data relationship tables. Employee ID First Name Last Name email Title Address Extension Department Department ID Hiring Date Department Phone # 0001 John Smith jsmith Accountant 1300 West st 5775 Accounting 2100 8/1998 407-366-5700 0002 Brian Miller badams Admin Assistant 1552 Palm dr 5367 Human resource 2300 4/1995 407-366-5300 0003 James Miller miller Inventory Manager 2713 Buck rd 5432 Production 2520 8/1998 407-366-5400 0004 John Jackson jackson_sam Sales Person 433 tree dr...
The Primary Key of the table recording this information is SheepID+WeighingDate. The table has not been...
The Primary Key of the table recording this information is SheepID+WeighingDate. The table has not been normalized beyond First Normal Form. That is, there are no ‘repeating groups’, but there may be Partial and Transitive Dependencies. SheepID Owner Birthdate WeighingDate Vet Weight VetPhoneNum K3922 McNab013 2013-05-12 2013-08-14 M330 22 7633088852 K3922 McNab013 2013-05-12 2014-06-02 S929 34 7609865463 K3922 McNab013 2013-05-12 2015-08-02 M330 43 7633088852 K3922 McNab013 2013-05-12 2016-07-30 P301 53 7682907965 K3922 McNab013 2013-05-12 2017-08-12 P301 52 7682907965 K3922 McNab013...
Problem 1 : Movies ER Model Consider a Database that keeps track of scenes filmed for...
Problem 1 : Movies ER Model
Consider a Database that keeps track of scenes filmed
for different movies. A movie uses a screenplay (or story) which is
broken down into scenes. The movie will also have the same scenes because it is a
movie of that screenplay. Not all screenplays in the database
become movies, but every movie is of a particular screenplay.
Also, a screenplay is used for only one movie. That is, there are
not two different movies...
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...
How can we assess whether a project is a success or a failure? This case presents...
How can we assess whether a project is a success or a
failure?
This case presents two phases of a large business transformation project involving the implementation of an ERP system with the aim of creating an integrated company. The case illustrates some of the challenges associated with integration. It also presents the obstacles facing companies that undertake projects involving large information technology projects. Bombardier and Its Environment Joseph-Armand Bombardier was 15 years old when he built his first snowmobile...
Fundamentals of Database Systems
Consider the following data. Arrows show the functional dependency Product Item ld QuantityItem Used uct Receipt Quantity Sales ription Number Num Description Date The arrows in this question indicated the determination of two attributes. For example, the arrow that goes ProductID to ProductDescription indicates that ProductID determines the ProductDescription, This in turn means that Productld can be considered as primary key for ProductDescription a) Write the tables b) Place the tables in 3rd normal form (if...
for question (c) do like this
3. A table to record the information of Dentists, Patients, and Appointments in a clinic is given below. DentistNo DentistName PatientNo PatientName PatientPhone AppointmentDate Appointment Time AppointmentFee On a single day each patient can have more than one appointment. It is known that DentistNo is unique for each dentist. PatientNo is unique for each patient. PatientNo must not be used as a composite key. A patient is allowed to see any dentist. (a) Use...
2) Consider the following table of information Primary Key (CourselD, SemesterlD) CoursetD I Senester TD 1 Places 1 Course Name IT101 1 2009-1 110I Programing IT1e1 I 2009-2 11e0 I Programming IT102 I 2009-11200 1 Databases IT102 I 2010-1 115I Databases IT103 2009-2 1120 I Web Design A. B. Normal Form Violation: Put into Sentence Structure: C. Normalized: 3) Consider the following: Primary Key ISBN ISBN Title Publisher Address A. B. Normal Form Violation: Put into Sentence Structure: C. Normalized:...
Problem 1 : Movies ER Model
Consider a Database that keeps track of scenes filmed
for different movies. A movie uses a screenplay (or story) which is
broken down into scenes. The movie will also have the same scenes because it is a
movie of that screenplay. Not all screenplays in the database
become movies, but every movie is of a particular screenplay.
Also, a screenplay is used for only one movie. That is, there are
not two different movies...
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...
How can we assess whether a project is a success or a
failure?
This case presents two phases of a large business transformation project involving the implementation of an ERP system with the aim of creating an integrated company. The case illustrates some of the challenges associated with integration. It also presents the obstacles facing companies that undertake projects involving large information technology projects. Bombardier and Its Environment Joseph-Armand Bombardier was 15 years old when he built his first snowmobile...
Most questions answered within 3 hours.
-
What mechanisms Drive speciation??
(I.e. what was Dawins theory on the orgin of species, and how...
asked 1 hour ago -
The manager at a car assembly plant believes that the mean
assembly time for a car...
asked 1 hour ago -
Which of the following is true of electron capture?
A) It decreases the nuclide's mass number...
asked 3 hours ago -
Assuming an efficiency of 43.10%, calculate the actual yield of
magnesium nitrate formed from 114.9 g...
asked 4 hours ago -
The highly pathogenic bacterium Clostridium
perfringens causes gangrene, a disease that results in the
destruction of...
asked 5 hours ago -
In the context of situation analysis, which of the following is
a category for analysis in...
asked 5 hours ago -
In a study of the gas phase decomposition of sulfuryl chloride
at 600 K SO2Cl2(g)SO2(g) +...
asked 5 hours ago -
75 g of 2-propanol (C3H8O) and 25 g of pentane are mixed in a
200 mL...
asked 5 hours ago -
The 2800-turn coil in a dc motor has an area per turn of 1.1 ×
10-2...
asked 6 hours ago -
Draw a combinational logic circuit diagram with a symbol inside
the box for two I/P of...
asked 6 hours ago -
The cliché we use quite a lot in finance is: there is a need to
maximize...
asked 6 hours ago -
In class we discussed the addition of HCl to alpha pinene. Would
you expect one or...
asked 6 hours ago