Working with databases/Create a database/Data types/Model answers

From WikiEducator
Jump to: navigation, search
OtagoPoly Logo S.png

Choosing data-types

Here are our suggestions for the data-types of the fields in the Books database:

Field Data-type
Year published Date/Time
Number of pages Number
Paperback or hardback Yes/No
Author Text
ISBN number Text
Item to be ordered Yes/No
Price purchased for Currency
Price sold for (retail price) Currency
Book Title Text

Return to the Data types page.