Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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) image text in transcribed
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Encompassing The Future Offshore Oil And Gas Operations Environment Health And Safety Performance Management Policy Economics Law And Environment

Authors: William J. Cairns; Ann G Wilkie; Judith Hackitt; Peter Hepburn; Ewan MacAngus; Rita Marcella; Hayley

1st Edition

1999766210, 9781999766214

More Books

Students also viewed these General Management questions

Question

How do you maximize your return without losing money?

Answered: 1 week ago