HomeworkLib
Question

In a relational database: The proper shorthand representation for the Entity called Package with a primary...

In a relational database:

The proper shorthand representation for the Entity called Package with a primary key of PackageNum and fields PackageWeight, PackageDimensions is:

  • A. Table (Package, PackageNum, PackageWeight, PackageDimensions)

  • B.(PackageNum, PackageWeight, PackageDimensions)
  • C.Package (PackageNum, PackageWeight, PackageDimensions)
  • D.Pack (PackNum, PackWght, PackDim)
engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

## thanks for asking the question ##

some general rules for shorthand representation of a entity of database are:

1.First, table name is written down.

2.Using paranthesis,list down all the columns and fields in the table within the paranthesis.

3.In this kind of representation,bold or underline data is used to represent a primary key.

therefore, the correct option is c)

C. Package(PackageNum, PackageWeight,PackageDimensions);

0 0
Add a comment
Know the answer?
Add Answer to:
In a relational database: The proper shorthand representation for the Entity called Package with a primary...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Please help me answer these: In the relational database model, an entity consists of one and...

    Please help me answer these: In the relational database model, an entity consists of one and only one entity instance (or record). A. True B. False 2. In the relational database model, the foreign key name does NOT have to be the same as the primary key name. A. True B. False 3. Logical relationships between tables (or entities) in the relational database model are created with primary and candidate keys. A. True B. False 4. In the relational database...

  • QUESTION 1 What is the most common relationship within a relational database? Select the best answer...

    QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an "entity'? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL...

  • A Pages entity in a relational database for tracking web browsing has the following attributes: PageID (the primary key, an integer number, required), PageURL (text, maximum 255 characters, required),...

    A Pages entity in a relational database for tracking web browsing has the following attributes: PageID (the primary key, an integer number, required), PageURL (text, maximum 255 characters, required), IPAddress (text, maximum 15 characters, required), ViewDateTime (date and time the page was viewed, required). (a) Write an SQL Data Definition Language command to create the table for this entity. (b) Write an SQL Data Definition Language command to add a column for a new attribute to this table: ViewDuration (duration...

  • Question 4 To represent a one-to-many relationship in a relational database design, _____. Group of answer...

    Question 4 To represent a one-to-many relationship in a relational database design, _____. Group of answer choices the key of the child is placed as a foreign key into the parent the key of the parent is placed as a foreign key into the child an intersection table must be created the key of the table on the "many" side is placed in the table on the "one" side the keys of both tables are joined into a composite key...

  • Part 1 - List at least four basic rules for identifying primary keys in a relational...

    Part 1 - List at least four basic rules for identifying primary keys in a relational database. Mention how you would go about identifying the foreign keys in your design. Briefly discuss foreign key ownership and how to indicate a foreign key in your relational database model. Part 2 - Describe at least two examples of common errors in entity relationship modeling. If possible, provide a graphical illustration of the problems and solutions. List some questions the designer should consider...

  • Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orde...

    Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orders(orderld, customerld, dateOrdered, dateRequired, status) Customer(customerld, customerLastName, customerStreet, customerCity, customerState, customer Lip OrderDetails(orderld.productld, quantity, lineNumber, amount) Products(productld, name, description, quantity, unitPrice) Account(accountNumber, customerld, dateOpened, creditCard, mailingStreet, mailingCity, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of...

  • An IT support organization within a large company wants to develop a relational database to keep...

    An IT support organization within a large company wants to develop a relational database to keep track of its work. We will call users of the organization's service CLIENTs. CLIENTs, as needed, submit requests for help called TICKETs. Each TICKET, in turn, can have multiple PROBLEM ITEMs. There are many SUPPORT SPECIALISTs in the organization. Eventually each PROBLEM_ITEM is assigned to a unique SUPPORT_SPECIALIST. Each SUPPORT SPECIALIST can have multiple PROBLEM ITEMs assigned to him or her. Since PROBLEM ITEMs...

  • The following are the main entity types of the academic institution database. For each entity type,...

    The following are the main entity types of the academic institution database. For each entity type, we provide some of the corresponding attributes. Use this information in order to: (a) Build an Enhanced E-R diagram; (b) Transform the Enhanced E-R diagram to a relational database. Identify the primary key(s) and the foreign key(s) for each relation. Draw the relational integrality constraints; (c) For each of the relations created, indicate its normal form. If the relation is not in the 3NF,...

  • How would you represent a one-to-many strong entity relationship in a physical relational database design?

    How would you represent a one-to-many strong entity relationship in a physical relational database design?

  • You have been assigned to a new development team. A client is requesting a relational database sy...

    You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future. You received an email from the client with the list shown below. Currently, this list tracks their daily business. To prepare for the meeting with the client, you develop a first draft prototype of a relational database. In your one page MS Word pdf report include the following:...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT