logo
   
    Password reminder
To register place your 1st order
 

Welcome!

Unlike most writing services, MarvelousEssays.com provides original, custom-written papers only

order telephone

   

The Company Database

← Government and BusinessNonverbal Communication in Business →

Buy custom The Company Database essay

The company database should include the below information and tables that have to be included.  The specific information should seek to indentify a specific aspect in the company. Tables are listed for clarity before designing a database so that the designer may have a clear view of the information required to be included in the data base (Davis, 2010). Below is a set of tables with the relevant information for each table

Company table

Information to be included in the data base tables

- The company’s name

- The city that the company is situated in

Suppliers table

-  The names of each supplier

- The city of each supplier

Purchases table

- The name of the company doing the purchases

- the purchase date of the transaction

- The number of items bought by each company or client

- The date of each transaction

Employee table

- The name of each employee

- The ID of each employee

- City of each employee

- Sex of each employee

- Data of birth  of each employee

Departmental table

- The ID of the department

- The name of the company

Perimeters to a database are included to restrict access to such database for parties that are not required to access private information or those who do not have permission to access the database according to Moody & Shanks (2002), such perimeters for access should be defined to allow only the intended party to log on or affect any change in the data base. An example of these perimeter conditions is as follows.

Logon credentials

Contact name

User  Name

Security R

Logon status

The last logo

Eg. Steve Jones

Jones01

Administrator

Active

10/06/09 6:03PM

 

 

 

 

 

 

 

 

 

 

 

Group table

 

administrator

Manager

Standard

Restricted

Browse

Create or edit group

 

 

 

 

 

Delete My groups

 

 

 

 

 

Delete Other users’ groups

 

 

 

 

 

Create/delete/edit my activities

 

 

 

 

 

Custom activity management

 

 

 

 

 

Manage my resources

 

 

 

 

 

Update my activities

 

 

 

 

 

Manage my priority list

 

 

 

 

 

Buy custom The Company Database essay

Related essays

  1. Nonverbal Communication in Business
  2. Offshoring
  3. Government and Business
  4. Business Memorandum Assignment
order now
 

Get 15% off your first custom essay order.

Order now

PRICES
from $12.99/PAGE
X