Sabbina_Assign3
.docx
keyboard_arrow_up
School
University of North Texas *
*We aren’t endorsed by this school
Course
MISC
Subject
Computer Science
Date
Jun 4, 2024
Type
docx
Pages
3
Uploaded by GeneralCaribou4318
Student Id:11673892
1 Crow Foot ER Diagram for the given business rules in the question. 2 The above table is in 1
st
NormalForm.
Desirable dependencies:
(INV_NUM,PROD_NUM) → SALE_DATE,PROD_LABEL,VEND_CODE,VEND_NAME,QUANT_SOLD,PROD_PRICE
The above table is in 2
nd
NormalForm. After removing partial dependencies.
Partial dependencies:
INV_NUM → SALE_DATE
PROD_NUM → PROD_DESCRIPTION, VEND_CODE, VEND_NAME, PROD_PRICE
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Please refer to the following diagram for Q19 to Q20.
PERSON
PK P_ID
P_LNAME
P_FNAME
ΕMPLOYΕ
P_ID
EMP_HIRE_DATE
STUDENT
P ID
STUDY ΜAIOR
PK, FK1
PK, FK1
19.
Which of the following statements is/are true?
(1) A Person must be either a Student or an Employee.
(2) A Person can neither be a Student nor an Employee.
(3) A Person must be a Student or an Employee or both.
a. (1) only
b. (3) only
c. (1) and (2) only
d. (1), (2) and (3).
arrow_forward
Please draw an EERD based on following description:
A rental car agency classifies the vehicles it rents into four categories: compact,
midsize, full-size, and sport utility. The agency wants to record the following data for
all vehicles: Vehicle_ID, Make, Model, Year, and Color. There are no unique
attributes for any of the four classes of vehicle. The entity type vehicle has a
relationship (named Rents) with a customer entity type. Customer has SSN, name and
phone number.
arrow_forward
Consider the following PRODUCT table (Primary key underlined).
True or False: The two last rows are allowed in the table
PRODUCT
PRODUCT ID PRODUCT_TYPE_CODE PRODUCT_PRICE PRODUC_NAME PRODUCT_DETAILS
Some Description
P1
РС-1
23.45
Introduction to
Access
Some Description
Some Description
Some Description
P2
PC-2
99.25
Plates
P3
PC-3
9.99
Forks
P4
PC-4
1200.45
Horizon 2000
Tread Mill
P5
PC-4
900.00
Soul F80
Some Description
True
False
arrow_forward
Material : Relational Algebra
Course : Database Systems
Create a Relational Algebra From Entity Relational Diagram (ERD) Below for:a) Displays books published in the last 5 years from 2020.b) Displays details of customers who have done shopping (using the Join operator)c) Displays email customers who have done shopping (using the Set operator)d) Displays the ISBN book that has never been purchased (using the Set operator)
arrow_forward
Type
ISBN
eBook
RelationName2 (AttrName1)
Primary key {AttrName1)
Price
Book
N
Order
Hardcopy
Date
Quantity
RelationName1 (AttrName1, AttrName2)
Primary key {AttrName1}
Foreign key {AttrName2} references RelationName2 (AttrName1)
M
CoverStyle
Customer
Id
Date
Name
Has
Convert the following E-R diagram to a collection of relations. Determine all the primary and foreign keys.
Use the following format to answer the question:
Payment
No
arrow_forward
Q2/ write the schema that descibes the following relations:
1- The course relation
course.id
title
deptname
Biology
Biology
Biology
Intro. to Computer Science Comp. Sci.
Comp. Sci.
Comp. Sci.
Comp. Sci.
Database System Concepts Comp. Sci.
Elec. Eng.
Finance
History
Music
Physics
credits
BIO-101
Intro. to Biology
4
BIO-301
BIO-399
CS-101
CS-190
CS-315
CS-319
CS-347
EE-181
FIN-201
HIS-351
MU-199
Genetics
4
Computational Biology
4
4
Game Design
Robotics
Image Processing
Intro. to Digital Systems
Investment Banking
World History
Music Video Production
Physical Principles
PHY-101
2- The section relation
course.id
secid
building rooIJumber
timeslot.id
semester
ynar
BIO-101
BIO-301
CS-101
CS-101
CS-190
CS-190
CS-315
CS-319
CS-319
CS-347
EE-181
1
Summer
Summer
Fall
2009
Painter
514
514
101
101
3128
2010
Painter
2009
Packard
1
Spring
1
Packard
2009 Taylor
2009 Taylor
2010 | Watson
2010
2010
Spring
Spring
E
Spring
3128
120
100
3128
3128
Spring
2.
Watson
2010 Taylor
2009 Taylor
2009 Taylor…
arrow_forward
Which normal form requires that, no non-key attribute should functionally depend on a part of the primary key?
3rd Normal Form
4th Normal Form
2nd Normal Form
1st Normal Form
arrow_forward
herpever applicable 2. Title field in Instructor table should allow only Mr., Ms., Mrs., Dr., Prof. as values apply check constraints
arrow_forward
Q7: An ERD about a company has been mapped to the following Relations.
Please choose the correct statement that describes the company
Employee(ID,E.Name, Salary)
Project(Name, Location, ID)
Project Location(Name, Location)
a. A company has several projects and employees. An employee can work on
one or more projects. A project can be located at several locations
b. A company has several projects and employees. An employee can work on
a single project only and each project has several employees. A project can
be located at several locations
c. A company has several projects and employees. An employee can work on
one or more projects. A project is located at a single location
d. A company has several projects and employees. An employee can work on
one project only. A project can be located at several locations
Employee
EID
001
002
003
004
005
006
Name
Ahmad
Ali
Sameh
Salem
Huda
Ali
Department
group by Name
order by EID;
a. TWO columns and FOUR records
b. TWO columns and ONE record
c. TWO…
arrow_forward
1. Design an Entity Relationship Diagram for the system above. 2. Write query that would return the names and contacts of all Local students. 3. Write a query that would return names, contact and locations of all departments that has a location text with Ave 3 as part of it. [hint: use the LIKE clause with “_” or “%”] 4. What would be the result returned for the following query: SELECT first_name, last_name, student_type.name, student_category.name FROM student, student_type, student_category WHERE stud_type_id = student_type.id AND stud_cat_id = student_category.id AND student_type.name = “Sandwich”; 5. Write a query that would present the first and last names, student type and category of all distance students. 6. What would be the result of the following query: SELECT student.id, first_name, last_name, contact, registration_type.name, course.code FROM student, registration, registration_type, course WHERE student.id = stud_id AND reg_type_id = registration_type.id AND…
arrow_forward
Question 1
Computer Science
Open the totalfees query in Design view. Modify the query by creating a calculated field that sums the total of registrationfee, guestfee, and workshopfee. Use totalfees as the name of the calculated field
arrow_forward
A relation that has no multivalued attributes is in _____ normal form.
arrow_forward
Convert the following Relation into INF, 2NF, and 3NF and show the functional dependencies.
StudentID StudentName Major CourselD CourseTitle InstructorName InstructorLocation Grade
D-Building
A-Building
C-Building
C-Building
A-Building
D-Building
A-Building
111
Kevin
CS
CS201
Bob
Computer
Marketing
Accounting
Accounting
Jeff
111
Kevin
CS
МАЗ3
Jeff
111
Kevin
CS
АCC234
Sarah
222
Alex
BA
АСC234
Sarah
B.
333
МАЗ33
Marketing
Computer
Marketing
Noor
MA
444
CS201
Bob
Luay
Adam
BA
A
555
AC
МАЗ33
Jeff
arrow_forward
Primary keys and candidate keys may both be assigned to the same attribute.
arrow_forward
def distance_between_entities(entity1, entity2):"""compute the haversine distance between the two entitiesAn entity is a tuple: (ID, City, State, Latitude, Longitude):param entity1::param entity2::return: the distance (in miles) between the entities"""pass
ENTITES LOOK LIKE THISID,City,State,Latitude,LongitudeA45419E,Plattsburgh,NY,44.704021,-73.471148A19312D,Aiken,SC,33.554433,-81.69588A90172S,Tuscaloosa,AL,33.170238,-87.616169A19394D,Alexandria,VA,38.819853,-77.059645A27218D,Pittsburgh,PA,40.47441,-79.950968A68626D,Meadville,PA,41.611599,-80.114891A17494D,Allentown,PA,40.602658,-75.469236A86034S,Tonawanda,NY,42.99704,-78.878659A45142D,Asheville,NC,35.602711,-82.567281A38298S,Atlanta,GA,33.844371,-84.47405A14497Y,Roswell,GA,34.055198,-84.370475A25954D,Austin,TX,30.326374,-97.771258B46374X,Fairhope,AL,30.480713,-87.861306B52199S,Cedar…
arrow_forward
The properties of the relation object can be used to implement the master-detail functionality which most appropriate for your application. You can delete a master-detail relation by selecting it in the Object Navigator and choosing Navigator => Delete. Discuss the Deletion of Relations in detail.
arrow_forward
Q1. Create these two relations, then insert the tuples.
(Instructor relation: ID is PK, dept_name is FK, set name not null and unique, every tuple
in salary must be greater than 35000 and less than 100000)
(Department relation: dept_name is PK)
Department
dept_name
building
budget
Biology
Comp. Sci.
Elec. Eng.
Watson
90000
Taylor
Taylor
Painter
100000
85000
Finance
120000
History
Painter
50000
Music
Packard
80000
Physics
Watson
70000
Instructor
ID
dept name
salary
name
Comp. Sci.
Finance
10101
Srinivasan
65000
12121
Wu
90000
15151
Mozart
Music
40000
Physics
History
Physics
Comp. Sci.
History
Finance
22222
Einstein
95000
32343
El Said
60000
33456
Gold
87000
45565
Katz
75000
58583
Califieri
62000
76543
Singh
80000
76766
Crick
Biolo
72000
Comp. Sci.
Elec. Eng.
83821
Brandt
92000
98345
Kim
80000
arrow_forward
SELECT P.BRAND_ID, B.BRAND_NAME, B.BRAND_TYPE,MAX(AVGPRICE)
FROM LGPRODUCT P INNER JOIN LGBRAND B ON P.BRAND_ID = B.BRAND_ID
(SELECT P.BRAND_ID, AVG (P.PROD_PRICE) AS AVGPRICE
FROM LGPRODUCT P
GROUP BY P.BRAND_ID)AS AVG_PRICE
GROUP BY P.BRAND_ID, B.BRAND_NAME, B.BRAND_TYPE
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT P.BRAND_ID, AVG (P.PROD_PRICE) AS AVGPRICE FROM LGPRODUCT P GROUP BY P.' at line 3
arrow_forward
Database Schema
The schema for the Ch07_FACT database is shown below and should be used to answer the
next several problems. Click this image to view it in its own tab.
FIGURE P7.56 THE CH07_FACT ERD
CHECKOUT
PATRON
PK
Check Num
PK Pat ID
FK1 Book_Num
FK2 Pat_ID
Check_Out_Date
Check_Due_Date
Check_In_Date
>0-----H-
Pat_FName
Pat LName
Pat_Type
BOOK
AUTHOR
PK
Book_Num
PK Au ID
Book_Title
Book_Year
Book_Cost
Book_Subject
FK1 Pat_ID
Au_FName
Au_LName
Au_BirthYear
WRITES
PK,FK1 Book Num
PK,FK2 Au ID
The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT)
library of e-books. FACT is a collection of current technology e-books for use by faculty and
students. Agreements with the publishers allow patrons to electronically check out a book,
arrow_forward
Page - 1
DBMS - TASK 1: Draw an ERD and Map it to relational schema.
Please complete reading page 1 before going to page 2.
In this task, you will be given a text that describes a company (in page 2). Each student
should complete the steps below to fully solve the task
Represent the company description as an ER-diagram, including all relevant constraints as the
following steps:
-
Each student should download Lucidchart app
Every student should use Lucidchart to draw the ERD
Edit
Lucidchart
Blank diagram
Select View Insert Arrange Help
80
What's New
Saved
Start a free trial to access unlimited shapes and documents! X
BIUAT-
2 px None None
408
Liberation Sans
▾
10 pt +
Shapes
O
Standard
×
T
Flowchart
000
☐ ODOT
☐ ☐ ☐ ☐ ☐☐
)>0 ×
TU Xx
14
<<
ΔΟ
▼ Shapes
ΠΑ
☐ ☐
Name
B
Present
MA
when you create
After each entity
ID
print screen, your
name include your
user ID should be
shown
university ID number
Department
0190334
Dep_ID
Employee
0190334
Name
arrow_forward
Child row is a related row where there is a ?
Primary key
Foreign key
Candidate key
Composite key
arrow_forward
Task 1:Create a database Entity and Relationship Diagram (ERD) for the following application (Submitted An image of the Diagram By using Any Application:Application:
The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community.
Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place.
Application models (page):
Login included:
login
registration
login included:
user name
password
New registration included:
name
E-mail
Password
phone number
date
National Identification Number
Home page included:
Request - applicant name - address - send message
Messages list form included:
list…
arrow_forward
Consider the following ER diagram:
storcid
address
description
value
Displays
Store
Memorabilia
The above diagram represents information pertaining to stores and the memorabilia that is
displayed within the stores.
a) Write the SQL statements to create the necessary tables to represent the above diagram,
representing as many constraints as possible. Note: you do not need to worry about
specifying types for the fields, but you do need to provide suitable foreign key option(s).
arrow_forward
Which normal form requires that, no non-key attribute should functionally depend on a part of the primary key?
arrow_forward
Look up the average evaluation score earned by instructor Egan for the Emergency Care course:
In cell E14, begin to enter a formula using the XLOOKUP
Use the instructor name in cell E12 as the value to look up.
Use a structured reference to the header row of the Evaluations table as the table to search.
Return the value in the range E4:I4.
I need help with the sttructured reference refered in #3
arrow_forward
11.
Foreign key is the one in which the ________ of one relation is referenced in another relation.
a.
Foreign key
b.
Primary key
c.
References
d.
Check constraint
arrow_forward
Task 1:Create a database Entity and Relationship Diagram (ERD) for the following application:Please include answer with detailed explanationKhair Application:
The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community.
Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place.
Application models (page):
Login included:
login
registration
login included:
user name
password
New registration included:
name
E-mail
Password
phone number
date
National Identification Number
Home page included:
Request - applicant name - address - send message
Messages list form included:
list of…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education
Related Questions
- Please refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME ΕMPLOYΕ P_ID EMP_HIRE_DATE STUDENT P ID STUDY ΜAIOR PK, FK1 PK, FK1 19. Which of the following statements is/are true? (1) A Person must be either a Student or an Employee. (2) A Person can neither be a Student nor an Employee. (3) A Person must be a Student or an Employee or both. a. (1) only b. (3) only c. (1) and (2) only d. (1), (2) and (3).arrow_forwardPlease draw an EERD based on following description: A rental car agency classifies the vehicles it rents into four categories: compact, midsize, full-size, and sport utility. The agency wants to record the following data for all vehicles: Vehicle_ID, Make, Model, Year, and Color. There are no unique attributes for any of the four classes of vehicle. The entity type vehicle has a relationship (named Rents) with a customer entity type. Customer has SSN, name and phone number.arrow_forwardConsider the following PRODUCT table (Primary key underlined). True or False: The two last rows are allowed in the table PRODUCT PRODUCT ID PRODUCT_TYPE_CODE PRODUCT_PRICE PRODUC_NAME PRODUCT_DETAILS Some Description P1 РС-1 23.45 Introduction to Access Some Description Some Description Some Description P2 PC-2 99.25 Plates P3 PC-3 9.99 Forks P4 PC-4 1200.45 Horizon 2000 Tread Mill P5 PC-4 900.00 Soul F80 Some Description True Falsearrow_forward
- Material : Relational Algebra Course : Database Systems Create a Relational Algebra From Entity Relational Diagram (ERD) Below for:a) Displays books published in the last 5 years from 2020.b) Displays details of customers who have done shopping (using the Join operator)c) Displays email customers who have done shopping (using the Set operator)d) Displays the ISBN book that has never been purchased (using the Set operator)arrow_forwardType ISBN eBook RelationName2 (AttrName1) Primary key {AttrName1) Price Book N Order Hardcopy Date Quantity RelationName1 (AttrName1, AttrName2) Primary key {AttrName1} Foreign key {AttrName2} references RelationName2 (AttrName1) M CoverStyle Customer Id Date Name Has Convert the following E-R diagram to a collection of relations. Determine all the primary and foreign keys. Use the following format to answer the question: Payment Noarrow_forwardQ2/ write the schema that descibes the following relations: 1- The course relation course.id title deptname Biology Biology Biology Intro. to Computer Science Comp. Sci. Comp. Sci. Comp. Sci. Comp. Sci. Database System Concepts Comp. Sci. Elec. Eng. Finance History Music Physics credits BIO-101 Intro. to Biology 4 BIO-301 BIO-399 CS-101 CS-190 CS-315 CS-319 CS-347 EE-181 FIN-201 HIS-351 MU-199 Genetics 4 Computational Biology 4 4 Game Design Robotics Image Processing Intro. to Digital Systems Investment Banking World History Music Video Production Physical Principles PHY-101 2- The section relation course.id secid building rooIJumber timeslot.id semester ynar BIO-101 BIO-301 CS-101 CS-101 CS-190 CS-190 CS-315 CS-319 CS-319 CS-347 EE-181 1 Summer Summer Fall 2009 Painter 514 514 101 101 3128 2010 Painter 2009 Packard 1 Spring 1 Packard 2009 Taylor 2009 Taylor 2010 | Watson 2010 2010 Spring Spring E Spring 3128 120 100 3128 3128 Spring 2. Watson 2010 Taylor 2009 Taylor 2009 Taylor…arrow_forward
- Which normal form requires that, no non-key attribute should functionally depend on a part of the primary key? 3rd Normal Form 4th Normal Form 2nd Normal Form 1st Normal Formarrow_forwardherpever applicable 2. Title field in Instructor table should allow only Mr., Ms., Mrs., Dr., Prof. as values apply check constraintsarrow_forwardQ7: An ERD about a company has been mapped to the following Relations. Please choose the correct statement that describes the company Employee(ID,E.Name, Salary) Project(Name, Location, ID) Project Location(Name, Location) a. A company has several projects and employees. An employee can work on one or more projects. A project can be located at several locations b. A company has several projects and employees. An employee can work on a single project only and each project has several employees. A project can be located at several locations c. A company has several projects and employees. An employee can work on one or more projects. A project is located at a single location d. A company has several projects and employees. An employee can work on one project only. A project can be located at several locations Employee EID 001 002 003 004 005 006 Name Ahmad Ali Sameh Salem Huda Ali Department group by Name order by EID; a. TWO columns and FOUR records b. TWO columns and ONE record c. TWO…arrow_forward
- 1. Design an Entity Relationship Diagram for the system above. 2. Write query that would return the names and contacts of all Local students. 3. Write a query that would return names, contact and locations of all departments that has a location text with Ave 3 as part of it. [hint: use the LIKE clause with “_” or “%”] 4. What would be the result returned for the following query: SELECT first_name, last_name, student_type.name, student_category.name FROM student, student_type, student_category WHERE stud_type_id = student_type.id AND stud_cat_id = student_category.id AND student_type.name = “Sandwich”; 5. Write a query that would present the first and last names, student type and category of all distance students. 6. What would be the result of the following query: SELECT student.id, first_name, last_name, contact, registration_type.name, course.code FROM student, registration, registration_type, course WHERE student.id = stud_id AND reg_type_id = registration_type.id AND…arrow_forwardQuestion 1 Computer Science Open the totalfees query in Design view. Modify the query by creating a calculated field that sums the total of registrationfee, guestfee, and workshopfee. Use totalfees as the name of the calculated fieldarrow_forwardA relation that has no multivalued attributes is in _____ normal form.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education