User Account

All Pages

Imagine that you work for a finance industry-based

Assignment Help Database Management System
Reference no: EM13380211

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

Reference no: EM13380211

Questions Cloud

Your company has put in the request for a new database : your company has put in the request for a new database system and you have been tasked with architecting the security
A company is interested in upgrading its current core : a company is interested in upgrading its current core infrastructure which comprises 2 100mbps switches which connect
A company is interested in upgrading its current core : a company is interested in upgrading its current core infrastructure which comprises 2 100mbps switches which connect
You were tasked to create an oracle database for a company : you were tasked to create an oracle database for a company to track their employees and projects. after speaking with
Imagine that you work for a finance industry-based : imagine that you work for a finance industry-based organization. your organization is looking to submit its database
Imagine that you work for a finance industry-based : imagine that you work for a finance industry-based organization. your organization is looking to submit its database
A multinational tour operator agency has gained new : a multinational tour operator agency has gained new business growth in the north american market through the use of
Assume you were a newly hired it security manager at a : assume you were a newly hired it security manager at a software development company that in the past hasnt paid much
1 in platosrepublic glaucon presents a three-part argument : 1. in platosrepublic glaucon presents a three-part argument meant to show that justice is not natural but rather

Reviews

Write a Review

Database Management System Questions & Answers

  Calculate canonical cover for set of functional dependencies

Calculate a canonical cover for above set of functional dependencies (show each step of your derivation with an explanation).

  Database to keeps track of students in university

University XYZ needs a database that keeps track of students, what classes they taken and the grades for each of the classes.

  Completing transaction using sql

Write down the complete transaction using SQL.

  What is file organization

What is file organization? what are file organization techniques.explain in detail? explain random file organization technique, multikey file organization technique?

  How protocol ensures serializability and deadlock freedom

To lock any other vertex, the transaction must have visited all the parents of that vertex and must be having a lock on one of the parents of the vertex. Show that the protocol ensures serializability and deadlock freedom.

  Design and build a prototype data warehouse

Design and build a prototype data warehouse using the data on Spend over £25,000 in the Science and Technology Facilities Council

  Create a table for patients with information

Create a table (by your own imagination) which comprises the least 25 patients with next information (columns): Calculate average of Value1 for each Gender.

  Create ascreenshot of each query and output data

Create 3 rows of data for each table ensuring that the referential integrity is valid and add the 30 rows of data to the appropriate table in your database (using any appropriate method available).

  Database management systems

Rubric for PowerPoint Presentation Points

  Relations of airline flight information

The relations given below keep track of airline flight information:Flights(flno: integer, from: string, to: string, distance:integer, departs: time, arrives: time, price: real)Aircraft(aid: integer, aflame: string, cruisingrange: integer)

  Expanded entity relationship model diagram

Each department has many employees assigned to it, but each employee works for only one department at one of the factories. An employee cannot work at more than one factory at a time.

  Problem on relational algebra

The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined)

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd