Question: Do you mind explaining what is right or wrong for course (MIS) Annual salary of each employee has to be stored in dollars and cents.

Do you mind explaining what is right or wrong for course (MIS)  Do you mind explaining what is right or wrong for course
(MIS) Annual salary of each employee has to be stored in dollars
and cents. The salaries vary from minimum of $25,000 to maximum of

Annual salary of each employee has to be stored in dollars and cents. The salaries vary from minimum of $25,000 to maximum of $200,000. Which of the following would be the most suitable data type? Selected Arswer: money PRIMARYKEY X For data kept by a single publisher - it contains an entity BOOK, the following is known about the four attributos identified as candidate keys BookName varchar (50), is always known for each book and no two books have the same book name. ISBN char(13), is unique and always known after book has been registered with book organization. Books in process of being published do not yet have: REFNumber char(10) is an internal 10 digit code assigned to every book the money plans for book are made. PubDate is the date on which the book is pubbshed. The publisher, never publishes two books on same date Pnor to publishing, every book still has a vatuo w trequently trough out the publication process. Based on the descnption above, the best suited attribude for primary key is: Weight data tyoe Weight is atwoys prosent and is a whole number. It vanos botwoen 1 to maximum of 1500 Which ONE of the following is the most appecpriate data type to use for Weight

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!