Completion and justification of DBA

Completion and justification of DBA actions for a given case study, addressing these learning outcomes:

– select and critically evaluate appropriate DBA tools for managing a database system
– critically discuss current developments in the database management field
In particular, you should compare different approaches to achieving the same DBA objective.
Case
The Amazing World of Arthur Smith is based in an industrial village created by a Victorian philanthropist whose name has unfortunately become lost in the mists of time. He or she wanted to provide ideal living conditions for the workforce who were engaged in a variety of light engineering tasks. Today, the engineering work has long gone and the village markets itself as a tourist attraction. The management committee, the members of which are firmly supportive of open source software, have pursuaded a knowledgable volunteer to implement a database management system but the volunteer has told them he is not fully confident with setting up users, groups, tablespaces, indexes etc. They have now approached you for help. The main databases consist of:
– Normal stock and trading data from the village retail outlets which changes constantly
– An asset register for the site which hardly ever changes, in fact it is hardly used at all
– A GIS containing the results of archaeological surveys – the local archaeologist tells you, with a cheerful grin, that the quantity of data is currently small but will one day be “absolutely humungous”
Assessment
You need to provide evidence that you can:
– Understand the purpose of the activities you propose. (This section will require references to appropriate sources which examine the broad principles.)
– Make a carefully argued case for using a particular set of tools to perform the DBA actions. PostgreSQL
Instructions
– Explain and justify the purpose of any actions you propose. These are likely to include creating users and groups, allocating storage, and creating appropriate indexes Include Harvard references to appropriate sources.
-Offer alternative means of implementing your suggestions, such as GUI vs character interface, and web interface vs standalone client software.

Solution

Stock Details:  Here are the details about the stock that contain following data

• Stock ID:   It is the ID that defines particular stock.
• Stock’s Owner:    The name of the owner of particular stock.
• Stock Quantity:    It holds all the available stock with their quantities.
• History of Stock Data:    History data of particular stock.
• Delisted Stocks:    A list of all those stocks are not available.
• Stock Current Price:    Here is the price of stock.

Users:  

1.    Admin: 
Admin can perform actions like: add, update, delete;
He can add or delete any Users, Retailers Details and Stock Details.
2.    Customers:
It can be buyer (who can purchase any stock) or seller (who can sell any stock).
3.     Retailers:
Retailers can sign up to website so that the other side people can see their stocks.
4.    Distributers:
Distributers who are the dealers. They make the deal with customers regarding stock and they will distribute them.
5.    Archaeologist :
Archaeologist will tell all the details of his researched data like what is the project name,
What are the monuments he searched.

Retailers Details:

Here will be the list of all retailers of village with their details as below:  Retailer ID, Retailer Name, Shop Name, Contact Information, and Address.
Customers Details:

• Customer ID
• Customer Type: Here are the types of customer; it tells Customer is Buyer or Seller.

Distributers Details:  The details about Distributers are as:

• Distributer ID, Distributer Name, Contact Information, Address,
• Distributer Job: Where to Dealer Distribute the Stock and make deal with the customer finally.

Archaeological Survey Data:  This is about all monuments data details that were searched in past. Details are as:

• Project Name: The name of the research project name.
• Survey Starting Date
• Survey End Date
• Monument Name: The searched monument name.
• Monument Site Location: It contains location name and latitude and longitude related to particular site location.
• Monument Quantities(if there is)

Stock Trade Details: Here are the details of stocks with their current prices.
Stock ID, Quantity,Date,Current Price, Low Price, High Price, Close Date, Customer ID.

Data Base Managements Details:
Indexing on Columns:  

• We will apply indexing on Stock Table columns Stock ID, Stock Quantity , Stock Price because in stock table stock quantity will be most searched and stock price also by the customers and every user .
• we will also apply indexing on  Stock Trade Details column that is close date, because everyone wants to know the closing date of the particular stock date and low price and high price will also be indexed because every user wants to know the low price stock and high price stock.

Lock on the tables:
We will apply read lock on Stock table and Stock Trade Details for particular session  so that customers can only reads data from the table but cannot update. The locked data is reserved for read by the current session. Other sessions can read the locked data. But they cannot write (update) the locked data.
We will apply write lock on Stock table and Stock Trade Details so that they are locked for current session when Admin will update data of these tables and other sessions cannot read and write data from those tables.
Implementing Suggestions:
CUI: 

• CUI which stands for Character user interface.
• In CUI one task runs at a time.
• Everything done by commands.
• Application : MS Dos

GUI:

• GUI Which stands for Graphical User interface.
• In GUI more tasks can run simultaneously.
• Work done by pointing devices like mouse
• Very user friendly
• Application : Window

GUI vs Character Interface
The interface should be GUI because it is user friendly instead of Character Interface where user have to remember all the commands to run the project or to do the any work.

Web Interface vs Standalone Client Software:
If we build Standalone Client Software so there will be less connected people because the owner of particular stock or company can connect to those people whom he knows.But if we are building our application using Web Interface it will benefits us to connect  large number of people; they can be any owner,buyers,sellers on internet and as the people increases the traffic on site will automatically increases and customers as well instead of building Standalone Client Software.