Physical database design does not include implementing files and databases (i.e., creating them and loading data...

Transcribed Image Text:

Physical database design does not include implementing files and databases (i.e., creating them and loading data into them). Physical database design produces the technical specifications that programmers, database administrators, and others involved in information systems construction will use during the implementation phase. Structured Query Language (SQL) is the standard language for creating and processing relational databases. The SQL language enables the creation, manipulation, querying, and general use of data found in a relational database. Specific functions of the SQL are broken down into individual subsets of the language. This includes the Data Definition Language (DDL) commands used for creating databases, the Data Manipulation Language (DML) which is used for querying the database, as well as the Data Control Language (DCL) which enables DBAs to control access and permissions to the database. 1. Use the Organization you chose in Week 1 and create Physical Design (decide Field structure, Table names, column names, Data types, and variable/fixed length characters) 2. Create the DBDL for your organization. 3. Begin coding the SQL statements for your organization by a. CREATE the Tables. b. INSERT values to the tables c. Create 10 or more records for your organization DB tables Physical database design does not include implementing files and databases (i.e., creating them and loading data into them). Physical database design produces the technical specifications that programmers, database administrators, and others involved in information systems construction will use during the implementation phase. Structured Query Language (SQL) is the standard language for creating and processing relational databases. The SQL language enables the creation, manipulation, querying, and general use of data found in a relational database. Specific functions of the SQL are broken down into individual subsets of the language. This includes the Data Definition Language (DDL) commands used for creating databases, the Data Manipulation Language (DML) which is used for querying the database, as well as the Data Control Language (DCL) which enables DBAs to control access and permissions to the database. 1. Use the Organization you chose in Week 1 and create Physical Design (decide Field structure, Table names, column names, Data types, and variable/fixed length characters) 2. Create the DBDL for your organization. 3. Begin coding the SQL statements for your organization by a. CREATE the Tables. b. INSERT values to the tables c. Create 10 or more records for your organization DB tables

Answer rating: 100% (QA)

since I dont have access to your chosen organization from Week 1 Ill provide a general example of how you can go about doing this Please adapt the following example to your organizations specific need... View the full answer