New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
computer sciences
databases
Database Systems Design Implementation And Management 11th Edition Carlos Coronel, Steven Morris - Solutions
Describe the Big Data phenomenon.
What does the term “3 vs” refers to?
What is Haddop and what are its basic components?
What is sparse data? Give an example.
Define and describe the basic characteristics of a NoSQL database.
Using the example of a medical clinic with patients and tests, provide a simple representation of how to model this example using the relational model and how it would be represented using the key-value data modeling technique.
What is logical independence?
What is physical independence?
How do you translate business rules into data model components?
Give an example of each of the three types of relationships.
What is a relational diagram? Give an example.
What is connectivity? (Use a Crow’s Foot ERD to illustrate connectivity.)
Write the business rule(s) that governs the relationship between AGENT and CUSTOMER.
Given the business rule(s) you wrote in Problem 1, create the basic Crow’s Foot ERD.
Using the ERD you drew in Problem 2 create the equivalent Object representation and UML class diagram.
Identify each relationship type and write all of the business rules.
Create the basic Crow’s Foot ERD for DealCo.
Typically, a patient staying in a hospital receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between PATIENT and ORDER. Similarly, each order can include several medications, creating a 1:M
United Broke Artists (UBA) is a broker for not-so-famous painters. UBA maintains a small network database to track painters, paintings, and galleries. A painting is painted by a particular artist, and that painting is exhibited in a particular gallery. A gallery can exhibit many paintings, but each
Using the ERD from Problem, create the relational schema. (Create an appropriate collection of attributes for each of the entities. Make sure you use the appropriate naming conventions to name the attributes.)
Convert the ERD from Problem 10 into the corresponding UML class diagram.
Create a Crow’s Foot ERD to include the following business rules for the ProdCo Company:a. Each sales representative writes many invoices.b. Each invoice is written by one sales representative.c. Each sales representative is assigned to one department.d. Each department has many sales
Write the business rules that are reflected in the ERD shown in Figure (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the €œ1€ to the €œM€ side,
Create a Crow’s Foot ERD for each of the following descriptions. (Note: The word many merely means “more than one” in the database modeling environment.)a. Each of the MegaCo Corporation’s divisions is composed of many departments. Each of those departments has many employees assigned to
Identify each relationship type and write all of the business rules. Discuss.
What does it mean to say that a database displays both entity integrity and referential integrity?
Why are entity integrity and referential integrity important in a database?
What are the requirements that two relations must satisfy in order to be considered union-compatible?
Which relational algebra operators can be applied to a pair of tables that are not union-compatible?
Explain why the data dictionary is sometimes called "the database designer's database."
Using the STUDENT and PROFESSOR tables shown in Figure Q3.8 to illustrate the difference between a natural join, an equijoin, and an outer join.
Create the basic ERD for the database shown in Figure.
Create the relational diagram for the database shown in Figure.
Create the table that results from applying a UNION relational operator to the tables shown in Fig Q3.11BOOTH_PRODUCT BOOTH_PRICEChips .............. 1.5Cola ............. 1.25Energy Drink .......... 2Chips .............. 1.25Chocolate Bar ......... 1
Suppose that you have the ERM shown in Figure Q3.14.During some time interval, a Driver can drive many Trucks and any Truck can be driven by many DriversHow would you convert this model into an ERM that displays only 1:M relationships? (Make sure that you draw the revised ERM.)
What are homonyms and synonyms, and why should they be avoided in database design?
How would you implement a l:M relationship in a database composed of two tables? Give an example.
Identify and describe the components of the table shown in Figure Q3.17, using correct terminology. Use your knowledge of naming conventions to identify the table€™s probable foreignkey(s).
Identify the foreign keys.
Create the ERM.
Create the relational diagram to show the relationship between DIRECTOR and PLAY.
What would be the conceptual view of the INDEX table that is described in question 22? Depict the contents of the conceptual INDEX table.
What is the difference between a database and a table?
A database user manual notes that, “The file contains two hundred records, each record containing nine fields.” Use appropriate relational database terminology to “translate” that statement.
Create the table that results from applying an INTERSECT relational operator to the tables shown in Fig Q3.11.BOOTH_PRODUCT BOOTH_PRICE Energy Drink......... 2
Using the tables in Figure Q3.11, create the table that results from MACHINE DIFFERENCE BOOTH.MACHINE_PRODUCT MACHINE_PRICEChips ............. 1.25Chocolate Bar ........... 1
For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided.
Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.
Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key.
Create the ERD to show the relationship between STORE and REGION.
Create the relational diagram to show the relationship between STORE and REGION.
Describe the type(s) of relationship(s) between EMPLOYEE and STORE.
Draw the ERD to show the relationships among EMPLOYEE, STORE, and REGION.
Create the relational diagram to show the relationships among EMPLOYEE, STORE, and REGION.
For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space provided.
Create the ERD to show the relationship between EMPLOYEE and JOB.
Create the relational diagram to show the relationship between EMPLOYEE and JOB.
Do the tables exhibit entity integrity? Answer yes or no and then explain your answer. Discuss.
Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. Discuss.
Create the ERD to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.
Create the relational diagram to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN.
Do the tables exhibit entity integrity? Answer yes or no and then explain your answer. Discuss in detail.
Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. Discuss in detail.
Identify the TRUCK table’s candidate key(s).
For each table, identify a superkey and a secondary key.
Create the ERD for this database.
Create the relational diagram for this database.
For each table, where possible, identify:a. The primary keyb. A superkeyc. A candidate keyd. The foreign key(s)e. A secondary key
Create the ERD. (Look at the table contents. You will discover that an AIRCRAFT can fly many CHARTER trips but that each CHARTER trip is flown by one AIRCRAFT. Similarly, you will discover that a MODEL references many AIRCRAFT but that each AIRCRAFT references a single MODEL, etc.)
Create the relational diagram.
Modify the ERD you created in Problem 25 to eliminate the problems created by the use of synonyms.
Draw the relational diagram for the design you revised in problem 27. (After you have had a chance to revise the design, your instructor will show you the results of the design change, using a copy of the revised database named Ch03_AviaCo_2).
Create the table that would result from applying the SELECT and PROJECT relational operators to the CHARTER table to return only the CHAR_TRIP, CHAR_PILOT, and CHAR_COPILOT attributes for charters flown by either employee 105 or employee 109.
Describe the type(s) of relationship(s) between STORE and REGION.
For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write none in the space provided. Discuss.
Create the table that would result from applying the SELECT and PROJECT relational operators to the CHARTER table to return only the CHAR_TRIP, CHAR_PILOT, and CHAR_COPILOT attributes for charters flown by both employee 105 and employee 109.
Create the table that would result from applying a DIFFERENCE relational operator of your result from problem 29 to your result from problem 30.
What two conditions must be met before an entity can be classified as a weak entity? Give an example of a weak entity.
Given the business rule “an employee may have many degrees,” discuss its effect on attributes, entities, and relationships.
Suppose you are working within the framework of the conceptual model in Figure Q4.5. a. Write the business rules that are reflected in it. b. Identify all of the cardinalities.
How would you (graphically) identify each of the following ERM components in a Crow’s Foot model?a. An entityb. The cardinality (0, N)c. A weak relationshipd. A strong relationship
Discuss the difference between a composite key and a composite attribute. How would each be indicated in an ERD?
What is a derived attribute? Give an example.
Discuss two ways in which the 1:M relationship between COURSE and CLASS can be implemented.
What three (often conflicting) database requirements must be addressed in database design?
Briefly, but precisely, explain the difference between single-valued attributes and simple attributes. Give an example of each.
What are multivalued attributes, and how can they be handled within the database design?
Write the ten cardinalities that are appropriate for this ERD.
Write the business rules reflected in this ERD.
What two attributes must be contained in the composite entity between STORE and PRODUCT? Use proper terminology in your answer.
The local city youth league needs a database system to help track children that sign up to play soccer. Data needs to be kept on each team and the children that will be playing on each team and their parents. Also, data needs to be kept on the coaches for each team. Draw the data model described
What is a strong (or identifying) relationship, and how is it depicted in a Crow’s Foot ERD?
What is a composite entity, and when is it used?
How is a composite entity represented in an ERD, and what is its function? Illustrate the Crow’s Foot model.
Describe precisely the composition of the DEPENDENT weak entity’s primary key. Use proper terminology in your answer.
Use the following business rules to create a Crow’s Foot ERD. Write all appropriate connectivities and cardinalities in the ERD.a. A department employs many employees, but each employee is employed by one department.b. Some employees, known as “rovers,” are not assigned to any department.c. A
Create a complete ERD in Crow’s Foot notation that can be implemented in the relational model using the following description of operations. Hot Water (HW) is a small start-up company that sells spas. HW does not carry any stock. A few spas are set up in a simple warehouse so customers can see
The Jonesburgh County Basketball Conference (JCBC) is an amateur basketball association. Each city in the county has one team as its representative. Each team has a maximum of 12 players and a minimum of 9 players. Each team also has up to three coaches (offensive, defensive, and physical training
Create an ERD based on the Crow’s Foot model, using the following requirements:An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative.The INVOICE is written for a single CUSTOMER. However, each customer
The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company’s training program. The HEG administrator gives you the description (see below) of the training group’s operating environment.The HEG
Showing 500 - 600
of 3228
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Last
Step by Step Answers
Get 50% OFF
Claim Now
.png)
.png)
.png)
.png)
