Create a plan of the necessary activities to databasse

Assignment Help Database Management System

Reference no: EM13784922

Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in preparing the documentation of the organization's sales database. You are asked to propose a data dictionary that can be used to document the following:

• Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID)

• Invoice (InvNumber, InvDate, EmpNumber, InvAmount, CustomerID)

• InvoiceLine (InvLineNumber, InvNumber, ProductNumber, Quantity)

• Product (ProductNumber, ProductDescription, ProductCost)

• Department (DepartmentID, DepartmentDescription)

• Job (JobID, JobDescription)

• Customer (CustomerID, CustomerName, CustomerAddress, CustomerPhone)

Write a three to four (3-4) page paper in which you:

1. Create a data dictionary that includes the following:

1. A description of the content for each field

2. The data type of each field

3. The format the data will be stored as in the field

4. The range of value for the field

5. A label, as required, if the attribute is a primary key or foreign key

Note: An example is shown in Table 7.3 in chapter 7 of the textbook.

2. Imagine that you are asked to identify the number of days that exist between the first invoice and last invoice for each month and complete the following:

1. Construct a query that will show the number of days that exist between the first invoice and last invoice, for each month, for each employee, using the DATEDIFF function. Be sure to provide the SQL script that will carry out this function.

2. Construct a query to show the expected payment date if invoices are due within 30 days of transaction.

3. Construct a query that will show distinct area codes of the customers.

3. Create a plan of the necessary activities that would be required to implement a valid database design process by including the following:

1. Steps in the conceptual design stage

2. Steps in DBMS selection stage

3. Steps in logical design stage

4. Steps in physical design stage

5. Task details of each activity within each stage

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow

APA or school-specific format. Check with your professor for any additional instructions.

• Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

Reference no: EM13784922

Questions Cloud

Howdoes p&g use positioning to differentiate the brands in a : Howdoes P&G use positioning to differentiate the brands in a particularproduct category?

Professional development throughout your career : This course provided you an overview of the discipline of psychology, including expectations for the psychology major, career options for students completing a bachelor's degree in psychology, and career options for students who pursue a graduate ..

Assignment on utility elasticity and demand : Utility Elasticity and Demand.

Compute the cost to produce one stereo system : Assuming that Kabana manufactures, on average, 1,300 stereo systems per month, enter each cost item on your answer sheet, placing the dollar amount per month under the appropriate headings. Total the dollar amounts in each of the columns. Compute ..

Create a plan of the necessary activities to databasse : Create a plan of the necessary activities that would be required to implement a valid database design process

How does incident aboard the walter scott show a contrast : How does the incident aboard the Walter Scott show a contrast between make - believe and reality? It's from Huckfinn book

How much safety inventory of cell phones : Weekly demand for iPhones at a store is normally distributed with a mean of 300 and a standard deviation of 200. Apple takes two weeks to supply an order for these phones. The store is targeting a CSL of 95 percent and monitors its inventory continuo..

Determining the cost to manufacture award products : Duncan Trophies Inc. uses a job order cost system for determining the cost to manufacture award products (plaques and trophies).

Corporate media & the threat to democracy issues : How has the role of the Print media changed in present day society? Is it still important to be able to read?

User Account

All Pages