Identifying Entities and Attributes

I’m working on a MySQL question and need guidance to help me study.

Struggling to find relevant content? Order a custom essay on
Identifying Entities and Attributes
Let our experts save you the hassle
Order Now

The project description developed in W1 Assignment 3 is a first draft, so consider it a rough draft. This means that you should continue to develop your idea.

The next step is to select some nouns in your project description. For example, a project has invoices, invoice distributions, and suppliers as nouns. These nouns are entities, or tables, that would be used to create the E-R model. Then, the adjectives and verbs that describe the nouns would become the attributes, or columns.

Therefore, in the example that we considered, we might have the following entities and attributes:

Invoices Invoice_Distributions Suppliers
# Invoice_id # Invoice_distribution_id # Supplier_id
Invoice_num Invoice_distribution_line_num Name
Invoice_type Line_type Address
Supplier_id Invoice_id

Using your knowledge of selecting entities and attributes, complete the following tasks for this week:

  • Review your project descriptions and come up with five entities and some attributes that describe the entities. Do not identify more than five attributes for each entity.
  • In a Microsoft Excel spreadsheet, define six columns (nouns) from the project description you submitted in W1 Assignment 3 that you consider key to your database. These will be the tables for the database. Then, in the rows for each column, define the attributes (adjectives).

You have taken your creative idea and started to move the nouns and adjectives you identified in a logical model—the E-R model. This will give you a working outline of the tables that will be created in the final script.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
s
Get personalized services with GPA Fix
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
We appreciate every review and are always looking for ways to grow. See what other students think about our do my paper service.
Other
Excellent
Customer 452813, August 21st, 2023
Business and administrative studies
Thank you very much for your help.
Customer 452861, September 16th, 2022
Other
Awesome Work!
Customer 452587, February 24th, 2022
History
thank you so much for the help, I really appreciate that.
Customer 452725, February 13th, 2022
Other
GREAT JOB THANK YOU.
Customer 452813, July 18th, 2022
Social Work and Human Services
Thank You, Don!!! :)
Customer 452587, November 9th, 2021
Social Work and Human Services
Great Work !!!
Customer 452587, November 9th, 2021
Social Work and Human Services
Perfect. Thank you.
Customer 452469, July 10th, 2021
Social Work and Human Services
Great Work!
Customer 452587, November 2nd, 2021
Human Resources Management (HRM)
Thank you for doing such an awesome job.
Customer 452701, June 30th, 2023
Social Work and Human Services
Great Work!
Customer 452587, November 2nd, 2021
Nursing
Great work. thank you again!
Customer 452707, August 7th, 2022
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Good News ! We now help with PROCTORED EXAM. Chat with a support agent for more information