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...
question One: Design an ER diagram for the following Dental Clinic database. Your diagram should have...
question One: Design an ER diagram for the following Dental Clinic database. Your diagram should have all the needed details. You may make any reasonable assumptions but you have to state them clearly. ------ The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary, birth-date and home-address (Box, City, Zip). Each client (patient) has a unique Code, name, home-phone, work-phone, address, and birth-date. Each client is assigned to one dentist. All future visits will...
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...
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...
DRAW AN ER DIAGRAM TO MAP IT OUT: The Problem: The database you design should be...
DRAW AN ER DIAGRAM TO MAP IT OUT:
The Problem: The database you design should be for the following scenario: OHIP wants to keep track of it's doctors and patients and hospitals. For the doctors, you must keep track of the doctor's license number. The license number is 4 character alphanumeric, for example 4RG2. Also, you must keep track of the doctor's first name (up to 20 letters), last name(up to 20 letters), specialty (up to 30 letters) and the...
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...
Due to your experience in designing the database for the "Legendary League" game, you have been...
Due to your experience in designing the database for the "Legendary League" game, you have been asked to design the ER diagram for a bigger database to manage the events for the "Legendary League" eSports Oceanic Championship (OC). The requirements are as follows: Registered teams compete in the OC. Each team has a name, and a number of team members. A team also maintains a rank throughout the OC, reflecting how well it is doing in the championship. Team members...
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...
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). •...
6-dt-content-rid-11 91 82071-1/courses/1 1025.201 860/Scanned%20from%20MIS%20Xeroxpdrag 3. (42 points) This problem was inspired by a real-world database...
6-dt-content-rid-11 91 82071-1/courses/1 1025.201 860/Scanned%20from%20MIS%20Xeroxpdrag 3. (42 points) This problem was inspired by a real-world database problem found in the news: Rental-owner database seen as solution to problem properties. A municipality (city) is creating a new database to help manage problems with rental properties within the city. They need to keep track of basic information (description, address, etc.)on the properties being rented within the city. They will store information on two types of rental properties, houses and apartments. These have...
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...
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...
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...
DRAW AN ER DIAGRAM TO MAP IT OUT:
The Problem: The database you design should be for the following scenario: OHIP wants to keep track of it's doctors and patients and hospitals. For the doctors, you must keep track of the doctor's license number. The license number is 4 character alphanumeric, for example 4RG2. Also, you must keep track of the doctor's first name (up to 20 letters), last name(up to 20 letters), specialty (up to 30 letters) and the...
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...
6-dt-content-rid-11 91 82071-1/courses/1 1025.201 860/Scanned%20from%20MIS%20Xeroxpdrag 3. (42 points) This problem was inspired by a real-world database problem found in the news: Rental-owner database seen as solution to problem properties. A municipality (city) is creating a new database to help manage problems with rental properties within the city. They need to keep track of basic information (description, address, etc.)on the properties being rented within the city. They will store information on two types of rental properties, houses and apartments. These have...
Most questions answered within 3 hours.
-
Your Skateboard manufacturing operation is broken up into two
seperate production areas. The first where the...
asked 9 minutes ago -
Ghost films are similar to global new waves and slow cinema in
that: They are primarily...
asked 7 minutes ago -
A survey of 2000 Ford owner found that 450 chose their car as
their favorite car...
asked 8 minutes ago -
Write a program in c++ to convert an expression written in infix
notation to be converted...
asked 8 minutes ago -
1. Which formula gives the standard error for all xbar
values? _______
a) σ/√n b) σ c)...
asked 15 minutes ago -
is it appropriate to use a normal distribution to approximate a
confidence interval for the population...
asked 26 minutes ago -
Choose the correct sample space (S) for the random experiment
that is described.
A pair of...
asked 29 minutes ago -
Provide clear answers to the following questions at the end of
your lab report.
Use the...
asked 37 minutes ago -
The equilibrium constant, Kc, for the following reaction is
1.20×10-2 at 500 K. PCl5(g) PCl3(g) +...
asked 43 minutes ago -
Consider stock-based compensation: stock options, restricted
stock and stock appreciation rights. Which of the following
statements...
asked 43 minutes ago -
In a survey of
2320
adults,
725
say they believe in UFOs. Construct a
99 %...
asked 54 minutes ago -
A
test was given and the scores were the following: 10 10 14 16 18 19...
asked 58 minutes ago