Hyper Market Customer Application Context Diagram The Application will be decomposed into 5 processes: Check latest promotions, Build shopping list, View shopping list, Search items and Check locations. App Data Flow Diagram contains one external entity (Customer). App Data Flow Diagram contains three data stores (Company, Warehouse and Shopping cart). Customer can receive promotion news from the Check Latest Promotions|| process and the news is provided by the Company database. A Customer can Build Shopping List by providing Items details and the details will be stored in the Shopping Cart database. The Warehouse database will also provide the Items details required to complete the process. A Customer can receive Items details by performing the Search Items process. He/she must provide an Item name for searching and the item details are returned from the Warehouse database after searched. A Customer can receive Supermarkets' physical location details by performing Check Locations and the details is provided by the Company database
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Step by step
Solved in 2 steps with 1 images