Homework Answers
--14
Student-Id->Grade is valid functional dependency. Because Grade of students can be identified unique by Student-Id. Id is unique for each student.
Instructor -Id -> Class - Code is not functional dependencies because both are unique and can be identified without any on of entity.
Instructor-Lastname->Instructor-id is not functional dependencies because last name can be repetitive and cannt identify instrutoin id with help of LastName
--15
False (Multivalued parameters will be removed in 1NF. A well designed database will be in 3NF or 2NF)
--16
Yes (Foreign key is repetitive. It is primary key of some other table. For example- Class -id is unique key of class table. In students table it will be repetitive because same class can be tagged to multiple students)
Please comment if any clarification required
Add Answer to:
Database
Could you help me to solve the problem? Thank you very
much!
In most colleges...
QUESTION 1 What is the most common relationship within a relational database? Select the best answer...
QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an "entity'? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL...
Subject: Database Notes: Please give me detailed answers so I could learn from this. Thank you....
Subject: Database
Notes: Please give me detailed answers so I could learn from
this. Thank you.
PS: This is a homework that I already submitted but did not know
whether my answer is right or wrong.
Pasien=Patient, namaLengkap=FullName,
ibuKandung=biologicalMother, tglLahir=birthDate, alamat=address,
dokter=doctor, spesialisasi=specialization,
taripkonsul=consultingFee, ranap=inpatient, wktMasuk=enterTime,
idRuang=idRoom, ruang=room, namaRuang=roomName, biaya=fee,
wktKeluar=outTime,
to explain some questions given below. pasienfidPasien varchar, namalengkap varchar, bukandung varchar, tgl Lahir date, alamat varchar) . dokter(idDr varchar, nama Lengkap varchar, spesialisasi varchar, tarip.per konsul UNSIGNED INT)...
Please help me solve the problem 3) a and b. Thank you very much!!! Suppose you...
Please help me solve the
problem 3) a and b. Thank you very much!!!
Suppose you are asked to estimate the 1st quartile (25% point) from a distribution. You are given a sample of size 30: 7.34 8.16 8.69 8.80 8.82 9.28 9.29 9.38 9.43 9.51 9.65 9.78 9.84 9.95 9.98 9.99 10.02 10.05 10.37 10.42 10.52 10.67 10.78 10.87 11.05 11.12 11.19 11.37 11.54 11.92 Given sorted here. a. If I just tell you the data is an id...
DATABASES You are required to design and implement a relational database to help the local community...
DATABASES You are required to design and implement a relational database to help the local community center better serve the residents in your neighborhood. Database Specifications: In your preliminary analysis, you have determined the following basic facts about the community center and the services it provides to the residents in the neighborhood: - The community center serves multiple areas which fall into different zip codes. - The community center provides collaborative family based care services. An immediate family is...
Hello, could you help me solve this question, please? Thank you very much! Question: (a) A...
Hello, could you help me solve this question, please? Thank you very much! Question: (a) A project has EIGHT (8) activities listed in the following table: Activity Immediate Predecessor (s) Time (Weeks) Activity Immediate Predecessor (s) Time (Weeks) A - 2 E C 3 B A 5 F C 7 C A 3 G D, E 2 D B 4 H F 3 (i) Use the GRAPH PAPER provided to construct a Gantt chart for the above project. [Note: You...
Please do not delete the questions. 1. What is the purpose of a database? 2. What...
Please do not delete the questions. 1. What is the purpose of a database? 2. What is the reason to use a database over a spreadsheet? 3. Based on the previous answers (#1 & #2), there is a simple rule of thumb. A spread sheet is used when there is _________________________. A database is used when there are _________________________. 4. Please answer followings. a) A group of 8 bits is called a ____________ (from Chapter 4). b) The answers of...
Hello! Please, help me solve this problem (7.88). And, please, explain answer. Thank You Very Much!!!...
Hello! Please, help me solve this problem
(7.88).
And, please, explain answer.
Thank You Very Much!!!
Please, solve by using this equations:
dV/dx = -w
dM/dx = V
7.87 and 788 For the beam and loading shown, (a) write the of the shear and bending-moment curves, (b) determine th tude and location of the maximum bending moment. Fig. P7.88
please use dia to draw the e-r diagram to create Entity - Relationship Diagrams then use MS access This project requires you to create a database design. Your design will be documented in a set o...
please use dia to draw the e-r diagram to create Entity -
Relationship Diagrams
then use MS access
This project requires you to create a database design. Your design will be documented in a set of Entity-Relationship Crow's Foot diagrams using the representation as shown in the lecture materials. Draw a set of Entity-Relationship diagrams to model the following scenario. The Maggs Realty Company wants to track the Sales Offices that they have across all of Ontario They are interested...
Please help me in both questions, thank you very much :) QUESTION 1 Alice owns a...
Please help me in both questions, thank you very much :)
QUESTION 1 Alice owns a cafe in the Brisbane CBD. Due to the large number of cafes in area, the market is highly competitive. 1. If Alice experiences economic losses, she would definitely leave the market immediately 2. Alice is a price taker. 3. If the market price is above the minimum ATC for the profit maximising quantity Alice produces, Alice is making an economic profit. Which of the...
Please help me on the SQL queries, thank you so much. Write a query to display the title and publisher as well as the p...
Please help me on the SQL
queries, thank you so much.
Write a query to display the
title and publisher as well as the publisher contact for each book
using JOIN...USING clause.
Write a query to show the
first and last names of customers who have ordered cooking books.
Use the WHERE clause to join the tables.
Write a query to show the
title, cost and ISBN of each book in the books table. If the book
has been ordered,...
QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an "entity'? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL...
Subject: Database
Notes: Please give me detailed answers so I could learn from
this. Thank you.
PS: This is a homework that I already submitted but did not know
whether my answer is right or wrong.
Pasien=Patient, namaLengkap=FullName,
ibuKandung=biologicalMother, tglLahir=birthDate, alamat=address,
dokter=doctor, spesialisasi=specialization,
taripkonsul=consultingFee, ranap=inpatient, wktMasuk=enterTime,
idRuang=idRoom, ruang=room, namaRuang=roomName, biaya=fee,
wktKeluar=outTime,
to explain some questions given below. pasienfidPasien varchar, namalengkap varchar, bukandung varchar, tgl Lahir date, alamat varchar) . dokter(idDr varchar, nama Lengkap varchar, spesialisasi varchar, tarip.per konsul UNSIGNED INT)...
Please help me solve the
problem 3) a and b. Thank you very much!!!
Suppose you are asked to estimate the 1st quartile (25% point) from a distribution. You are given a sample of size 30: 7.34 8.16 8.69 8.80 8.82 9.28 9.29 9.38 9.43 9.51 9.65 9.78 9.84 9.95 9.98 9.99 10.02 10.05 10.37 10.42 10.52 10.67 10.78 10.87 11.05 11.12 11.19 11.37 11.54 11.92 Given sorted here. a. If I just tell you the data is an id...
Hello! Please, help me solve this problem
(7.88).
And, please, explain answer.
Thank You Very Much!!!
Please, solve by using this equations:
dV/dx = -w
dM/dx = V
7.87 and 788 For the beam and loading shown, (a) write the of the shear and bending-moment curves, (b) determine th tude and location of the maximum bending moment. Fig. P7.88
please use dia to draw the e-r diagram to create Entity -
Relationship Diagrams
then use MS access
This project requires you to create a database design. Your design will be documented in a set of Entity-Relationship Crow's Foot diagrams using the representation as shown in the lecture materials. Draw a set of Entity-Relationship diagrams to model the following scenario. The Maggs Realty Company wants to track the Sales Offices that they have across all of Ontario They are interested...
Please help me in both questions, thank you very much :)
QUESTION 1 Alice owns a cafe in the Brisbane CBD. Due to the large number of cafes in area, the market is highly competitive. 1. If Alice experiences economic losses, she would definitely leave the market immediately 2. Alice is a price taker. 3. If the market price is above the minimum ATC for the profit maximising quantity Alice produces, Alice is making an economic profit. Which of the...
Please help me on the SQL
queries, thank you so much.
Write a query to display the
title and publisher as well as the publisher contact for each book
using JOIN...USING clause.
Write a query to show the
first and last names of customers who have ordered cooking books.
Use the WHERE clause to join the tables.
Write a query to show the
title, cost and ISBN of each book in the books table. If the book
has been ordered,...
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