Question

5 points)*list all of the data that needs to be kept track of for the scenario above in a 1nf (flat file) table (20 points)*use the normalization technique and form the 3nf tables (25 points)*write out the create table command in sql for creating the database you have designed, make sure to use the right data types, constraints, and constraint references. (20 points) *write one sql insert into values ( ); command for each table in your database

Answer 1

Indicate the values to be added as well as the column names: INSERT INTO table_name (column1, column2, column3, ...).

What is Database?

A database in computing is a structured collection of data that is electronically accessible and stored.

Large databases are housed on computer clusters or cloud storage, whilst small databases can be stored on a file system.

Data modeling, effective data representation and storage, query languages, security and privacy of sensitive data, and distributed computing challenges, such as providing concurrent access and fault tolerance, are all part of the design of databases.

In order to collect and process data, a database management system (DBMS) communicates with applications, end users, and the database itself.

The primary tools offered to manage the database are also included in the DBMS software. The combined database, database management system, and related applications are referred to as.

Hence, Indicate the values to be added as well as the column names: INSERT INTO table_name (column1, column2, column3, ...).

learn more about database click here:

brainly.com/question/518894

#SPJ4