View the step-by-step solution to:

How do I get an Attribute in MySQL using E-R diagram to get a column_A count and column_B total

How do I get an Attribute in MySQL using E-R diagram to get a column_A count and column_B total


 

 

Top Answer

Suppose that there is an ER diagram that contains id,firstname and lastname which is... View the full answer

countandtotaloutput.PNG

Sign up to view the full answer

Other Answers

Your scenario above depicts a derived attribute, where the... View the full answer

ERD.PNG

1 comment
  • CREATE DATABASE abc; USE abc; CREATE TABLE 'YourEntity'( columnA int not null, columnB int not null ) /*Insert Data here*? SELECT count(columnA), total(columnB); This will be the code to create the database and table. Then to view the derived attributes, you call the count() and total() functions to give the values
    • brownraph
    • May 17, 2018 at 9:21am

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online