Consider the ER diagram in Figure 1. It represents a database for tracking leases and the...
Consider the ER diagram in Figure 1. It represents a database for tracking leases and the items being leased.
Question 1
What are the supertypes? __________________________________________________
How do you know? ________________________________________________________
Question 2
What are the subtypes? ____________________________________________________
How do you know? ________________________________________________________
Question 3
Must an Item be a Truck, Computer, or Furniture? _______________
How do you know? ________________________________________________________
Question 4
Can an Item be both a Truck and a Computer or Furniture? _______________
How do you know? ________________________________________________________
Question 5
What field in Items is the discriminator? _______________
Consider the ER diagram in Figure 2. It represents a database for patients in a hospital.
Question 6
What are the supertypes? __________________________________________________
How do you know? ________________________________________________________
Question 7
What are the subtypes? ____________________________________________________
How do you know? ________________________________________________________
Question 8
Must a Patient be a Resident or Outpatient? _______________
How do you know? ________________________________________________________
Question 9
Can a Patient be both a Resident and an Outpatient? _______________
How do you know? ________________________________________________________
Figure 1
Figure 2
Homework Answers
No Figures : Figure1 And Figure 2 Is Present in The Question.Please put the images by editing the question and revert me back in comment section
Add Answer to:
Consider the ER diagram in
Figure 1. It represents a database for tracking leases and the...
1 pts Based on the following ER Diagram from the database called "Student Financial." What SQL...
1 pts Based on the following ER Diagram from the database called "Student Financial." What SQL statement would you use to answer the following question? Student Tuition PKPSUID PK tutionID FirstName Pays (1.1-FX Student LastName SemesterCost Email Scholarships Department DueDate What are the names of all departments that contain the word "art" in them? (Provide a list of departments, no repeats) SELECT [Select] FROM Student WHERE [Select) Based on the following ER Diagram from the databa "Student Financial." What SQL...
Problem 1 : Movies ER Model Consider a Database that keeps track of scenes filmed for...
Problem 1 : Movies ER Model
Consider a Database that keeps track of scenes filmed
for different movies. A movie uses a screenplay (or story) which is
broken down into scenes. The movie will also have the same scenes because it is a
movie of that screenplay. Not all screenplays in the database
become movies, but every movie is of a particular screenplay.
Also, a screenplay is used for only one movie. That is, there are
not two different movies...
Help with database creation - create a visio ER diagram of the scenerio below.. thanks The...
Help with database creation - create a visio ER diagram of the
scenerio below.. thanks
The registrar's office at Weber State University wants you to create a new database to support an future application that will help their department better keep track of the scheduled classes offered each semester, including the specific course sections and lecturers appearing in the schedule, and the students registering for courses according to the published schedule. Courses (think course catalog) may or may not be...
Would you please help me with this homework ? 1- Explain what requirements this ER diagram...
Would you please help me with this homework ?
1- Explain what requirements this ER diagram is implementing
2- Draw an ER diagram (relationships) for the following business
rules in a company:
• A salesperson manages one or many other salespeople while a
salesperson is managed by only one salespeople.
• A salesperson can be an agent for many customers but a customer
is managed by only one salesperson.
• A customer can place many orders. But an order can...
LAN adapter A H B 2 6 C (router) E D Figure 2: LAN network diagram...
LAN adapter A H B 2 6 C (router) E D Figure 2: LAN network diagram IL Question 4 (a) Consider the LAN in Figure 2 i. How many subnets can you find? Write down the labels (letters) of the hosts in each subnet i. What is the physical topology of the subnet(s)? i. How does the switch know A is reachable via interface 1, B reach- able via interface 2 and so on (Use a simple example to briefly...
Part I: Creating ER Diagrams PLEASE COMPLETE EVERY QUESTION Question 1 (25 points): Consider the following...
Part I: Creating ER Diagrams PLEASE COMPLETE EVERY QUESTION Question 1 (25 points): Consider the following scenario. • A Pokémon character has a unique number; a name; stamina, attack and defense values; a date introduced; and one or more moves. • A move has a name, is either quick or special, and has an accuracy and power points. • A Pokémon type has a type name, a description and a type count (the number of characters with that type). •...
1. Consider a grocery supermarket planning to computerize their inventory management. The items on shelves will...
1. Consider a grocery supermarket planning to computerize their inventory management. The items on shelves will be marked with Radio Frequency Identification (RFID) tags and a set of RFID reader-devices will be installed for monitoring the movements of the tagged items. Each tag carries a 96-bit EPC (Electronic Product Code) with a Global Trade Identification number, which is an international standard. The RFID readers are installed on each shelf on the sales floor. The RFID system consists of two types...
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...
Q.1] Write SQL statements based on the tennis database schema (practice homework 5) Get all the different tow...
Q.1] Write SQL statements based on the tennis database schema (practice homework 5) Get all the different town names from the PLAYERS table. 2. For each town, find the number of players. 3. For each team, get the team number, the number of matches that has been played 'for that team, and the total number of sets won. 4. For each team that is captained by a player resident in "Eltham", get the team number and the number of matches...
Question 3 (a) Draw an ER diagram in term of entity, attribute and relationship for a...
Question 3 (a) Draw an ER diagram in term of entity, attribute and relationship for a SMART FOOD VENTURE proposal. [14 marks] (b) Identify the relational keys are Superkey, candidate key, primary key, alternate key and foreign key. Describe each of them with reference to the sample database tables that you had created. [6 marks] SMART FOOD VENTURE NETWORKING SDN BHD 4-Nov-09 e PASAR Introduction: SMART FOOD VENTURE is a wholesale company supplying meat-chicken that mainly concentrates around Manjung and...
1 pts Based on the following ER Diagram from the database called "Student Financial." What SQL statement would you use to answer the following question? Student Tuition PKPSUID PK tutionID FirstName Pays (1.1-FX Student LastName SemesterCost Email Scholarships Department DueDate What are the names of all departments that contain the word "art" in them? (Provide a list of departments, no repeats) SELECT [Select] FROM Student WHERE [Select) Based on the following ER Diagram from the databa "Student Financial." What SQL...
Problem 1 : Movies ER Model
Consider a Database that keeps track of scenes filmed
for different movies. A movie uses a screenplay (or story) which is
broken down into scenes. The movie will also have the same scenes because it is a
movie of that screenplay. Not all screenplays in the database
become movies, but every movie is of a particular screenplay.
Also, a screenplay is used for only one movie. That is, there are
not two different movies...
Help with database creation - create a visio ER diagram of the
scenerio below.. thanks
The registrar's office at Weber State University wants you to create a new database to support an future application that will help their department better keep track of the scheduled classes offered each semester, including the specific course sections and lecturers appearing in the schedule, and the students registering for courses according to the published schedule. Courses (think course catalog) may or may not be...
Would you please help me with this homework ?
1- Explain what requirements this ER diagram is implementing
2- Draw an ER diagram (relationships) for the following business
rules in a company:
• A salesperson manages one or many other salespeople while a
salesperson is managed by only one salespeople.
• A salesperson can be an agent for many customers but a customer
is managed by only one salesperson.
• A customer can place many orders. But an order can...
LAN adapter A H B 2 6 C (router) E D Figure 2: LAN network diagram IL Question 4 (a) Consider the LAN in Figure 2 i. How many subnets can you find? Write down the labels (letters) of the hosts in each subnet i. What is the physical topology of the subnet(s)? i. How does the switch know A is reachable via interface 1, B reach- able via interface 2 and so on (Use a simple example to briefly...
Q.1] Write SQL statements based on the tennis database schema (practice homework 5) Get all the different town names from the PLAYERS table. 2. For each town, find the number of players. 3. For each team, get the team number, the number of matches that has been played 'for that team, and the total number of sets won. 4. For each team that is captained by a player resident in "Eltham", get the team number and the number of matches...
Question 3 (a) Draw an ER diagram in term of entity, attribute and relationship for a SMART FOOD VENTURE proposal. [14 marks] (b) Identify the relational keys are Superkey, candidate key, primary key, alternate key and foreign key. Describe each of them with reference to the sample database tables that you had created. [6 marks] SMART FOOD VENTURE NETWORKING SDN BHD 4-Nov-09 e PASAR Introduction: SMART FOOD VENTURE is a wholesale company supplying meat-chicken that mainly concentrates around Manjung and...
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