I am working on pset8/mashup.db and seem to be stuck into this for long. Actually the documentation per CS50 says that we should consider reading readme.txt and US.txt for finding the data types for the fields in my mashup.db . In readme.txt there are 12 fields specified. When I hover over US.txt which is a TSV file I see that there seem to just 11 of those fields in one row because of which it becomes unclear which data type should be text/real/numeric. It's not clear which data in a row in US.txt corresponds to which of the fields. Or may be I am missing some clue?


Check the readme file. The 12 fields are given with their respective data type for sql.

| improve this answer | |

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .