Sabbina_Assign3

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).

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.

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

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…

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)

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…

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

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

herpever applicable 2. Title field in Instructor table should allow only Mr., Ms., Mrs., Dr., Prof. as values apply check constraints

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…

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

A relation that has no multivalued attributes is in _____ normal form.

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

Primary keys and candidate keys may both be assigned to the same attribute.

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

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…

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.

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

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,

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

Child row is a related row where there is a ?     Primary key     Foreign key     Candidate key     Composite key

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…

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).

Which normal form requires that, no non-key attribute should functionally depend on a part of the primary key?

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…

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

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

Write SQL code for the following design schema of three tables. The tables should have the following properties: sales table has a primary key on SalesNumber and it is set to AUTO-INCREMENT.products table has a primary key on number and it is set to AUTO-INCREMENT, they is an unique index on prodidsalesdetails table has a primary key on number and it is set to AUTO-INCREMENT, they is an index on prodid. They is a one-to-many relationship between the salesdetails.SalesNumber andsales.SalesNumber fields. There is a one-to-many relationship between the products.prodid and salesdetails.prodid fields. There is to be a delete constraint on the product.prodid field a record in the product table should not be allowed to be deleted if they exist a matching prodid in the salesdetails table. Primary and foreign keys should be implemented in the appropriate tables. Referential Integrity should be enforce at the database level, where appropriate for example, if a sales record is deleted all…