A Guide to SQL
9th Edition
ISBN: 9781111527273
Author: Philip J. Pratt
Publisher: Course Technology Ptr
expand_more
expand_more
format_list_bulleted
Question
thumb_up100%
Chapter 2, Problem 1TD
Program Plan Intro
Shorthand representation of the relational
- The shorthand representation is used to represent the database table in an easier and an understandable way by using primary keys.
- The step wise process for representing a shorthand representation of a database structure is as follows:
- First, the Table Name is written down.
- Using paranthesis, list down all the columns or fields in the table within the paranthesis.
- From the shorthand representation, data such as primary keys can be identified.
- In this kind of representation, bold or underline data is used to represent a Primary key.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
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 CUSTOMER
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.
Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design to support the following requirements.
There is no relationship between customers and sales reps. When a customer places an order, any sales rep can process the order and create the invoice. On the invoice, you need to identify both the customer placing the order and the sales rep responsible for the invoice. Draw an E-R diagram for the new design.
Chapter 2 Solutions
A Guide to SQL
Ch. 2 - Prob. 1RQCh. 2 - What is an attribute?Ch. 2 - What is a relationship? What is a one-to-many...Ch. 2 - Prob. 4RQCh. 2 - What is a relation?Ch. 2 - Prob. 6RQCh. 2 - Prob. 7RQCh. 2 - How do you qualify the name of a field, and when...Ch. 2 - Prob. 9RQCh. 2 - What is a primary key? What is the primary key for...
Ch. 2 - Prob. 11RQCh. 2 - Prob. 12RQCh. 2 - Define second normal form. What types of problems...Ch. 2 - Define third normal form. What types of problems...Ch. 2 - Prob. 15RQCh. 2 - Prob. 16RQCh. 2 - List the changes you would need to make to your...Ch. 2 - Prob. 1TDCh. 2 - Prob. 2TDCh. 2 - Prob. 3TDCh. 2 - Prob. 4TDCh. 2 - Prob. 5TDCh. 2 - Prob. 1CATCh. 2 - Identify the functional dependencies in the...Ch. 2 - Prob. 3CATCh. 2 - Determine the functional dependencies that exist...Ch. 2 - Prob. 2SCGCh. 2 - Prob. 3SCG
Knowledge Booster
Similar questions
- Problem Statement: You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1– 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track ofsimilar information for suppliers as well (although instead of supplier first and last name, there will just be a suppliercompany name). The database should maintain the data on products that are offered. Information about whichproduct is offered by which supplier should also be maintained. Finally, which customers have purchased whichproducts should also be tracked (note that we are only interested in which customers bought which product, but notconcerned about the date or how many were bought). 1.1 Business Rules: Assumptions for the business model are as follows:•Only customers that have purchased one or more products will exist in…arrow_forwardSubject: 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…arrow_forwardIndicate 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.arrow_forward
- Subject: 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. You are required to design a database for a car championship. The requirements are as follows: In the championship, each car’s information such as the car model, the top speed and the acceleration will be stored, and it is identifiable through a unique car ID. Each car will be drove by only one driver. Each driver’s info such as the unique driver number, driver name and the experience level of the driver are stored as well. A driver may have many trainers from more experience drivers and these experience drivers would have at least one trainee who follow them. Each of these drivers are usually supported by a team which each team have a name and is identifiable through the team number. Usually, a team would have at least one driver in the race. Every race would…arrow_forwardTask 1: ER diagram for give scenario Consider building a database for a shopping mall with requirements as follows: Each product of the shopping mall has a unique project No, and also has a name, a supplier name, a category, a purchase price and a selling price. Products need to be supplied from suppliers. Each product has one supplier, but a supplier may supply many products for the shopping mall. Each supplier has a supplier name and address. A purchase order for product from a supplier has a unique order No, and a date. The order specifies one or more products and their quantities required for a product. A sales order for product to customers has a unique order No, and a date. The order specifies one or more products and their quantities required for a product The shopping mall has warehouses. Each warehouse has a warehouse number, an address and a contact phone number. Each warehouse has shelves to store products. Each shelf has a shelf-number and a capacity. The shelf…arrow_forwardYou 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…arrow_forward
- 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.arrow_forwardAssignment Brief: Some of the most difficult decisions that you face as a database developer are what tables to create and what columns to place in each table, as well as how to relate the tables that you create. Normalization is the process of applying a series of rules to ensure that your database achieves optimal structure. Normal forms are a progression of these rules. Each successive normal form achieves a better database design than the previous form did. Based on your understanding for the various normal form respond to the following problems and provide the optimal answer/solution. Problem#1: 1st Normal Form (1NF) Consider the Students table, with the primary key underlined, and the following data: Students: Alpha 100111 Email doe@usna.edu Name Courses GradePoints NN204, SI204, IT221 SM223, EE301 SI204 John Doe 2,3,3 Matt Smith 092244 113221 smith@usna.edu black@usna.edu 4,4 Melinda 3 Black NN204, SI204, IT221 090112 Tom Johnson Johnson@usna.ed 4,2,3 u a) Is the Students table…arrow_forwardYour job as a database designer is to design a database with a schema that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, photograph, sculpture), and its price must be stored. Pieces of artwork also classified into groups of various kinds, for example, portraits, still lives, works by Picasso, or works of the 19th century; a given piece may belong to more than one group. Each group is identified by a name (like those just given) that describes the group and property. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique ID, name, address, total amount of dollars spent in the gallery, and the artists and groups of art that the customer tends to like. Draw the ER diagram for the database.arrow_forward
- Normalization works through a series of stages called normal forms. For most purposes in business database design, the normalization process. stages are as high as you need to go in five two four threearrow_forwardCourse : Database System Construct the relational model of the following scenario. System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The…arrow_forwardpls 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 outsidearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning