Working with databases/Create a database/Data types/Model answers
From WikiEducator
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.