Query Development and Testing

Architecture

Issues and Limitations

The only limitation in newly integrated database management system in which the data security is necessary according to the different set of domains based on which the user’s data can be critical with which the properly executed information should be processed with the complete information management with which the proper controlling of the information with which the analytical structure of the database can be affected.

There should be the proper framework for data security with which the processing of the information analysis can be functional with which the complete analytics should be verified with the process level integrations whereas the proper database management systems should have the complete database backup copies which can be used in the case of data loss.

CustomersInventory Order GDiamond Color CaratDiamond ClarityDiamond CutRetail StoreCustomerIDPKCustomerNameAddressInventoryIDPKCostCityStatePhone#PriceCaratClarityCutColorInventoryIDFKPKQuantityCutomerIDFKPKOrderIDPKOrderDateShippedDateColorIDPKColorless D,E,FNear Colorless G,H,I,J,KInventoryIDFKFaint Yellow K,L, and MCaratIDPKWeightInventoryIDFKClarityIDPKIFVVS1InventoryIDFKVVS2CutIDPKExcellentVery GoodVS1VS2InventoryIDFKStoreIDPKAddressStateCityZIPCustomerIDFKI1SI1SI2I3I2Good

Customers Inventory Order G Diamond Color Carat Diamond Clarity Diamond Cut Retail Store CustomerID int FK PK CustomerName int FK PK Address int FK PK InventoryID int FK PK Cost int FK PK City int FK PK State int FK PK Phone# int FK PK Price int FK PK Carat int FK PK Clarity int FK PK Cut int FK PK Color int FK PK InventoryID int FK PK Quantity int FK PK CutomerID int FK PK OrderID int FK PK OrderDate int FK PK ShippedDate int FK PK ColorID int FK PK Colorless D,E,F int FK PK Near Colorless G,H,I,J,K int FK PK InventoryID int FK PK Faint Yellow K,L, and M int FK PK CaratID int FK PK Weight int FK PK InventoryID int FK PK ClarityID int FK PK IF int FK PK VVS1 int FK PK InventoryID int FK PK VVS2 int FK PK CutID int FK PK Excellent int FK PK Very Good int FK PK VS1 int FK PK VS2 int FK PK InventoryID int FK PK M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 M1 M2 M3 M4 StoreID int FK PK Address int FK PK State int FK PK City int FK PK ZIP int FK PK int FK PK CustomerID int FK PK M1 M2 M3 M4 I1 int FK PK SI1 int FK PK SI2 int FK PK I3 int FK PK I2 int FK PK Good int FK PK M1 M2 M3 M4