Question 1 Given the two relations in figure 1 below, list the following: a. Entities b. Attributes c. Data or values E1 C1 Name= John Smith Name= Sunco Oil Address= 2311 kirby Houston, Texas 77001 Headquarters= Houston Age= 55 Presiddent= john Smith Home_phone= 713-749-2630

Question 1 Given the two relations in figure 1 below, list the following: a. Entities b. Attributes c. Data or values E1 C1 Name= John Smith Name= Sunco Oil Address= 2311 kirby Houston, Texas 77001 Headquarters= Houston Age= 55 Presiddent= john Smith Home_phone= 713-749-2630

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 2MC

See similar textbooks

Similar questions

Which of the following defines a relationship in which data can have multiple occurrences in each entity? one-to-one one-to-many many-to-many none of the above
a. What characteristics do tables that conform to the concept of well-informed relations have? b. Describe a dependency diagram and explain its purpose c. Normalize the relation given below OrderNum OrderDate PartNumber PartName UnitPrice PartQuantity SupplierNumber SupplierName SupllierStreet SupplierCitr SupplierSate SupplierZip
A.What characteristics do tables that conform to the concept of well-informed relations have? B Describe a dependency diagram and explain its purpose C. Normalize the relation given below OrderNum OrderDate PartNumber PartName UnitPrice PartQuantity SupplierNumber SupplierName SupllierStreet SupplierCity SupplierSate SupplierZip
Consider the following relations about NBA: P LAY ER(pid, pname, nation). Each tuple describes a player with pid being the player’sid, pname his name, and nation his nationality. The table has a primary key pid. T EAM(tid, tname). Each tuple describes a team with tid being the team’s id, and tnameits name. The table has a primary key tid. REGIST ER(pid, tid, salary, year). Each tuple records the fact that a certain player (indicated by pid) played for a certain team (indicated by tid) in a specific year with an annual income given in salary. The table has a primary key (pid,year ). Note that a player may belong to different teams in different years. (a) Find the names of the teams and the corresponding year that “Michael Jordan” ever playedfor. (b) Find the names of all players of the team “Heat” in year 2020. (c) For each player, display his pid, and the first and last years in which he played. (d) Find the pids of all players that played from 2010 through 2020 (i.e., such a…
Consider the following relational schema, representing five relations describing shopping transactions andinformation about credit cards generating them [the used notation is explained above].SHOPPINGTRANSACTION (TransId, Date, Amount, Currency, ExchangeRate, CardNbrCREDITCARD, StoreIdSTORE)CREDITCARD (CardNbr, CardTypeCARDTYPE, CardOwnerOWNER, ExpDate, Limit)OWNER (OwnerId, Name, Surname, BirthDate, Job, IncomeLevel, Level)CARDTYPE (CardType, Circuit, Issuer, Address, Country, CardName, Color)STORE (StoreId, Name, Address, Country, Zone, Web, Email, Type)1) Answer the following questions considering the domain described by the previous relational schema:1.1. How many transactions can be generated by a given credit card? (provide the minimum and themaximum number)1.2. How many shopping transactions occurred in the same store can be associated with a givenidentifier? (provide the minimum and the maximum number)2) Write the SQL query representing the following request:2.1. Determine the…
Question 19 Which of the following is a relationship between two entities? Group of answer choices unary relationship binary relationship reciprocal relationship dual relationship
Given the entity STUDENT and attributes: ST_INTIAL, ST_LNAME, ST_FNAME, ST_EMAIL, ST_PHONE . Use the Chen notation to depict the relationships:
Draw an ERD that shows the entities, attributes, primary key(s), foreign key(s), and relationships. Each relationship must be labeled. List all identifying relationships (if any). List all non-identifying relationships (if any). List all independent entities (if any). List all dependent entities (if any). Whenever patients are seen for the first time, they complete a patient information form that asks their name, address, phone number, and insurance carrier, all of which are stored in the patient information file. Patients signed up to be seen by doctor must be a member of at least one insurance carrier. Each time a patient visits the doctor, an insurance claim is generated and will later be sent to the carrier for payment. The claim must contain information about the visit, such as date, purpose, and cost. It would be possible for a patient to submit two claims on the same day. The relational notation for the database is: Patient (Patient ID, Name, Address, Phone, Primary Carrier,…
Exercise 3 Manufacturer A manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used. Create an ERD to show how you would track this information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality. Assumptions A supplier can exist without providing components. A component does not have to be associated with a supplier. A component does not have to be associated with a product. Not all components are used in products. A product cannot exist without components. List of Entities and the Attributes List of Relationship and Cardinalities Draw the Conceptual Model Draw the Logical Model with…
Which of the following is the correct relational model of the entity Judge (ignore foreign key due to Manage relationship)? (A) JUDGE ( JudgeID(PK), Name, FirstName, LastName, Title, YearPractice ) (B) JUDGE ( JudgeID(PK), FirstName, LastName, Title, YearPractice ) (C) JUDGE ( JudgeID(PK), Name, YearPractice ) (D) JUDGE ( JudgeID(PK), Name(PK), FirstName, LastName, Title, YearPractice ) Which of the following is the correct relational model of the entity Client? (A) CLIENT ( ClientID(PK), Phone, DoB, Age )(B) CLIENT ( ClientID(PK), Phone, DoB )
Q. Modify the Er diagram given below and add these Weak entity Identifying relationship Weak relationship Key attribute Composite attribute Multivalued attribute Derived attribute Relationships 1. One to One 2. One to Many 3. Many to One 4. Many to Many Skip the ones that are already present U can draw it on a page too
COM. Q. CUSTOMER (CID, NAME, STREET, CITY, STATE, AGE) SALE (PID, CID, DATE, COST) PART (PID, PNAME, COLOR) The meaning of these relations is straightforward; for example, SALE has one tuple for every part sold to a customer. Primary key attributes are underlined. For instance, PID and CID together form the primary key of relation SALE. SALE.PID is a foreign key that refers to PART.PID, while SALE.CID is a foreign key that refers to CUSTOMER.CID. Write SQL statements for the following retrieval and update operations. Retrieve the names of all the customers from the city of "Trenton' who bought a part at a cost less than $50. No duplicates should appear in the answer. Retrieve the names of red parts bought by a customer who is younger than 40 and from a customer who is older than 40. Delete all parts that are never bought by a customer from "Trenton" (this is a data change statement). Retrieve the names of the customers who never bought a green part. Retrieve the names of the…

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

E1	C1
Name= John Smith	Name= Sunco Oil
Address= 2311 kirby Houston, Texas 77001	Headquarters= Houston
Age= 55	Presiddent= john Smith
Home_phone= 713-749-2630