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

Create a diagram for a database with at least 5 tables. This should show your table names and column names. Show the relationships between the tables. Write a statement explaining your database design (why did you use the tables that you did). Create a database in Access based on your diagram. Include all tables in your diagram. Tables should each have a minimum of 5 rows. Create 5 SQL statements using your database. At least 2 of these should be manipulation statements (insert, update, etc). The others should be select statements. Explain what your sql statements do and how they would be useful to your database.

Answer 1

Question

Chapter 2, Problem 2TD

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

Create a diagram for a database with at least 5 tables. This should show your table names and column names. Show the relationships between the tables. Write a statement explaining your database design (why did you use the tables that you did). Create a database in Access based on your diagram. Include all tables in your diagram. Tables should each have a minimum of 5 rows. Create 5 SQL statements using your database. At least 2 of these should be manipulation statements (insert, update, etc). The others should be select statements. Explain what your sql statements do and how they would be useful to your database.

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.

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