(Week 10) part c and d please

The first step in designing a relational database is to define its fields by specifying a field name and a data type. Integer, date, and data types are used for fields containing data that might be mathematically manipulated. The data type is used for fixed-length fields containing text that is not intended to be mathematically manipulated. The data type is a variable-length field for entering text. The data type is used to store true/false and yeso data. The data type can be used to store URLs. The data type is used to store binary data, such as MP3 files and graphics. When designing fields, a database designer can also include field formats, field rules, and lookup routines to reduce data entry errors. The number of tables in a database can be determined by a process called, which helps a database designer group fields into record types and avoid data redundancy. A database designer must also consider how to sort or index records. The key for a table specifies the order in which records are stored and indicates where new records are inserted in a table. Indexing provides an alternative way to organize records, using a series of keys and pointers to temporarily arrange data without affecting the physical sequence of records specified by the sort order. SQL is a database language that generally works behind the scenes as an intermediary between the database software provided to users and the database itself. Although the specifications for searches and other database tasks are collected by easy-to-use graphical user interfaces, those specifications are converted into SQL which can communicate directly with the database. An SQL query contains SQL, such as SELECT, FROM, INSERT. JOIN, and WHERE, plus that specify the details of the command. Records can be removed from a database using the SQL command. Records can be added to a table using the SQL command. To search for data, you can use the SQL command. Changing or replacing the data in a field requires the SQL command. SQL also provides a(n) command that can be used to temporarily consolidate two tables so that data can be accessed simultaneously from both of them