Shorthand representation of the relational database structure: 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. Entity Relationship Diagram (ERD): Entity relationship diagram is basically a picture or snapshot about the business system. It means that the information stored and created is represented by this diagram. Entities may represent the physical object, event, or concept. An attribute is a property of an entity. Relationship denotes the link between the entities. If an independent child entity is present in a relationship then it is called a non-identifying relationship. If a dependent child entity is present in a relationship then it is called a non-identifying relationship.

Question

Indicate 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.

Answer 1

Question

Chapter 2, Problem 3TD

Program Plan Intro

Shorthand representation of the relational database structure:

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.

Entity Relationship Diagram (ERD):

Entity relationship diagram is basically a picture or snapshot about the business system. It means that the information stored and created is represented by this diagram.

Entities may represent the physical object, event, or concept.

An attribute is a property of an entity.

Relationship denotes the link between the entities.

If an independent child entity is present in a relationship then it is called a non-identifying relationship.

If a dependent child entity is present in a relationship then it is called a non-identifying relationship.

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

Indicate 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…

Write a query to display the first name, last name, and email address of employees hired from January 1, 2005, to December 31, 2014. Sort the output by last name and then by first name. Write the answer to each query and the result of the query (screen capture). You should submit all design work, program documentation, and relevant sample screen shots of your implementation. A script file with all database creation and table populating is required.