In the lessons to this point in the course, the data to be inserted into a database and table has been literal constants
Posted: Sun Jul 10, 2022 11:30 am
In the lessons to this point in the course, the data to beinserted into a database and table has been literal constants, suchas "Billy." For the purposes of learning T-SQL and its capabilitiesthis is a good way to start out. However, most of the time, thedata to be "inserted" into a database is in some form of storagemode. The data could be on a hard disk drive, a CD or a DVD, thumbdrive, even magnetic tape. Data stored electronically can bedifficult, but not near as difficult of the non-electrical ornon-digitized data stores. Assume that you are tasked withpopulating a newly installed RDBMS with a company's data that hasnever been computerized. You have paper, paper, and, did I mentionpaper? Identify three ways you could use to convert the data on thepaper documents into the database and its tables. Who can come upwith the most creative and novel way to do so?