Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

3.48 Rating (155 Votes )

There are 3 Steps involved in it

Step: 1

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information System

Authors: James A. Hall

7th Edition

978-1439078570, 1439078572

More Books

Students also viewed these Databases questions

Question

13. What is meant by the term SWOT analysis?

Answered: 1 week ago