Indicate the changes (using the shorthand representation) that you would need to make the original KimTay Pet supplies database design (see Figure 2-1) to support the following requirements. A customer is not necessarily represented by a single sales rep, but they can be represented by several sales reps. When a customer places an order, the sales rep who gets the commission on the invoice must be in the collection of sales reps who represent the customer.
Q: You are to design a Hospital database. So before creating the database, your task is to draw the ER…
A: The database structure is described with the help of a diagram called as Entity Relationship…
Q: draw the conceptual EERD where you should include the enhanced features.
A: ANSWER: Conceptual EERD: The drawn out substance relationship (EER) model is a language for…
Q: INDICATE THE CHANGES(USING SHORTHAND REPRESENTATION) YOU WOULD NEED TO MAKE TO THE ORIGINAL KIMTAY…
A: To indicate the changes needed to KIMTAY database for handling the given query: A CUSTOMER IS NOT…
Q: You are to design a Hospital database. So before creating the database, your task is to design the…
A: This is very simple. An ER diagram, called an entity-relationship model, describes the interest in a…
Q: Indicate the changes (using the shorthand representation) that you would need to make to the…
A: Shorthand representation of the relational database structure: The shorthand representation is…
Q: Normalization functional dependencies have what characteristics?
A: Functional dependencies It is a specific connection between two characteristics inside a table: main…
Q: Indicate the changes (using the shorthand representation) that you would need to make to the…
A: SOLUTION -
Q: indicate the changes(using the shorthand representation)that you would need to make to the original…
A: ITEM_ID which is unique and primary key in ITEM table can act as a identifier for ITEM. Using…
Q: You are asked to design a database for an University. This particular university has multiple…
A:
Q: As a stage of designing the Semuarasa restaurant database, some entity information and documents are…
A: Normalization:⦁ Food_Menu Table: 1NF (First Normal Form) Rules are as follows:⦁ Each…
Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…
A: All lower case Underscore separator between root and suffix Foreign keys have the same name as…
Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…
A: There is only one error in the above code and that is the ALTER TABLE command on the address table.…
Q: 1. Create an ER diagram. To do this, you can use in MS Word the option Insert -> Shapes. 2. Create…
A: The shared description states the requirements of the database model for sales for a motorcycle…
Q: Write the proper sequence of activities for the design of a video rental database. (The initial ERD…
A: Given: Write the proper sequence of activities for the design of a video rental database. (The…
Q: KimTay Pet Supplies database design (see Figure 2-1) to support the following requirements. A…
A: the solution is an given below :
Q: Implement a new independent entity phone in the Sakila database. Attributes and relationships are…
A: SQL: Database management is done using a programming language called SQL, or Structured Query…
Q: Indicate the changes (using the shorthand representation) that you would need to make to the…
A: Question 1.) Indicate the changes (using the shorthand representation) that you would need to make…
Q: ou will need to create the database tables and choose sensible data types for each column. Make sure…
A: DBMS stands for Database Management System, which is a software system used for managing and…
Q: 5.6 LAB - Implement independent entity (Sakila) Implement a new independent entity phone in the…
A: First check whether phone_id column exists in your customer, staff, and store table or not. If…
Q: A attribute can be further subdivided to yield additional attributes.
A: Solution - In the given question, we have to select the correct answers among the given options.
Q: Subject: Database Topic: EERD -Based on the information given below, draw the conceptual EERD…
A: Enhanced entity-relationship charts are progressed information base outlines basically the same as…
Q: Write the proper sequence of activities for the design of a video rental database. (The initial ERD…
A: Given, Write the proper sequence of activities for the design of a video rental database. (The…
Q: Indicate the changes (using the shorthand representation) that you would need to make to the…
A: Steps to draw an ER diagram: Identify the entities required Identify the attributes and the key…
Q: Assignment Brief: Some of the most difficult decisions that you face as a database developer are…
A: A table is in 1NF when all the values of a tuple in it are single values and cannot be further…
Q: Task 1: ER diagram for give scenario Consider building a database for a shopping mall with…
A: The entities identified based on the given business rules and requirements as below:- Supplier…
Q: StayWell also rents out properties on a weekly basis to students attending summer school in the…
A: For this database design, there will be 3 tables - student , property, rental. Student_no is primary…
Q: Your job as a database designer is to design a database with a schema that captures all the…
A:
Q: Design a survey form of your own. Fill it out as it might have been completed during the database…
A: The survey form six tables. Table name and their attributes are as follow: Branch (BranchNum,…
Q: You are asked to design a database for an University. This particular university has multiple…
A: University Database
Q: pls help me : Draw an ER diagram according to the following requirements: Database to manage daily…
A: Let's see the solution in the next steps
Indicate the changes (using the shorthand representation) that you would need to make the original KimTay Pet supplies
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
- INDICATE THE CHANGES(USING SHORTHAND REPRESENTATION) YOU WOULD NEED TO MAKE TO THE ORIGINAL KIMTAY PET SUPPLIES DATABASE DESIGN TO SUPPORT THE FOLLOWING REQUIREMENTS. A CUSTOMER IS NOT NESSESARILY REPRESENTED BY A SINGLE SALES REP, BUT THEY CAN BE REPRESENTED BY SEVERAL SALES REPS. WHEN A CUSTOMER PLACES AN ORDER THE SALES REP WHO GETS THE COMMISSION ON THE INVOICE MUST BE IN THE COLLECTION OF SALES REPS WHO REPRESENT THE CUSTOMERIndicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design in the event that the original Requirement 3 is changed as follows. For an item, store the item’s ID, description, category, and price. In addition, for each location in which the item is located, store the value of the location, the description of the location, and the number of units of the item stored in the location. Draw an E-R diagram for the new design.Design a survey form of your own. Fill it out as it might have been completed during the database design for Henry Books. For any questions you have too little information to answer, make a reasonable guess. (Ray Henry, the owner of a bookstore chain named Henry Books, gathers and organizes information about branches, publishers, authors, and books. Each local branch of the bookstore has a number that uniquely identifies the branch. In addition, Ray tracks the branch’s name, location, and number of employees. Each publisher has a code that uniquely identifies the publisher. In addition, Ray tracks the publisher’s name and city. The only user of the Book database is Ray, but you do not want to treat the entire project as a single user view. Ray has provided you with all the reports the system must produce, and you will treat each report as a user view. Ray has given you the following requirements: User View 1 Requirements: For each publisher, list the publisher code, publisher name, and…
- Need help in ER diagrampls help me : Draw an ER diagram according to the following requirements:Database to manage daily medical examination and treatment in the hospital (not interested in treating inpatients):- The hospital has many doctors and nurses from different departments. Each doctor and nurse belongs to only one department- The patient when he comes to the doctor will be created a patient record if it is the first visit- Each visit will be made a medical record and assigned an initial clinic. Each visit is attended by a doctor and an assistant nurse.- The doctor may ask the patient to perform tests, x-rays, endoscopy, ....- After the results are available, the patient returns to the original clinic for the doctor to read the results and prescribe medicine if any- Patients can buy medicine in the hospital pharmacy or buy it outsideSubject: Database Topic: EERD Please use UML Modelling Notation. (Don't use Chen’s Notation or Crow’s Feet Notation) -Based on the information given below, draw the conceptual EERD where you should include the enhanced features. A car dealership wishes to maintain data about the customers who purchase a car. Each customer may purchase one or more vehicles and each vehicle can be purchased by many different customers over time (for example, a customer maypurchase a new vehicle, trade that vehicle in and someone else can purchase the vehicle traded in.) Data that the dealership wishes to keep regarding customers includes customer identification number, name, address, homephone, work phone, cell phone and e-mail address. Information about vehicle includes vehicle identification number, make, model, year, transmission type, engine size and color. Vehicles can be a member of one of the following categories: cars, trucks, minivans or SUVS. A vehicle can be amember of only one category at a…
- You are to design a Hospital database. So before creating the database, your task is to design the ER diagram based on the following data requirements: The hospital has departments. Each department has a name, department ID, location. Location consists of floor number and wing number (which will contain the values North, South, East or West). b. Doctors work for the department. Doctors have license number., name, title, multiple specializations. Some doctors supervise other doctors. c. A patient will have a name, unique ID. may have more than one phone number, age, height, weight and symptoms. d. Patients take appointments from doctors. Appointment date and time is recorded. e. A patient may have an attendant. An attendant will have his/her name and relationship with the patient as a record in the database. The hospital allows 1 attendant with each patient. Write down any assumptions you may have made.You will need to create the database tables and choose sensible data types for each column.Make sure to maintain entity and referential integrity, and implement all the above constraints.Since other developers work in parallel on other parts of the system, you will need to strictly follow the above specification to correctly implemented in your database. Otherwise, the other software will not be able to use your database. This means, one needs to be able to rely on all constraints being correct, the spelling of table and column names being as given, and that the data types that you chose will allow for sensible data to be added to the database in the future.For testing purposes, you are asked to insert the data specified below into the tables, but no other data except this.In short:1. You will need to create the tables as specified2. You will need to add the data specified Please use the 3.sql and implement your tables using the sketched CREATE TABLE commands. Add the necessary queries…You are to design a Hospital database. So before creating the database, your task is to draw the ER diagram based on the following data collected and analyzed: A hospital will have a name, unique id, multiple helpline numbers (one for doctor's appointment, one for ambulance, one for bill information and one for other services' info) and locations. A hospital may have more than one location as it may have different branches and each of the locations will have a building no., street address, road no. and city name. A patient will have a name, unique ID, may have more than one phone number, age, height, weight and symptoms. A patient takes an appointment in a hospital and the appointment date is recorded. A patient may have an attendant. An attendant will have his/her name, contact numbers and relationship with the patient as a record in the database. Due to the covid situation, the hospital authorities will only allow 1 attendant with 1 patient.
- PLZ HELP WITH THE FOLLOWING: We will assume that the Computer Science Department at a university has an agreement with the publishers to allow faculty and students to have free exclusive access to the e-books online through their website. They need you to design a database for them using the following business rules: The faculty and students (we refer to them in our system as clients) can electronically check out any book at any time. A book must have at least one author but can have more authors. An author must have written at least one book or more to be included in the system. A book may have never been checked out, but can be checked out many times by the same client or different clients over time. A client may have never checked out a book or they may have checked out many books over time. To simplify determining which client currently has a given book checked out, a M:N relationship between BOOK and CLIENT should be maintained. The information recorded for each book is book…StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)