Databise Design Describe three SQL queries to provide information to the end users for this system.  At least one must be a join.  These can be real SQL statements or written in English Table Name Attribute Description Data Type Null Keys Sales Sales_ID Contains unique Sales ID INT No Primary key   Product_Price Price of the Product VARCHAR(30) No     Sales_Date Sales of the Date VARCHAR(30) No     Quantity Quantity of product DATE No     Personal_ID Personal_ID ofSales INT No Foreign key   Cashier_ID Cashier_ID of Sales INT No Foreign key     Table Name Attribute Description Data Type Null Keys Product Product ID ID of the Product INT No Primary key   Product_name Name of the Product VARCHAR(50) No     Brand_name Brand of the name VARCHAR(50) No     Quantity Quantity VARCHAR(20) No     Pharmaceutical_ID Pharmaceutical of the ID INT No Foreign Key

Question

Databise Design

Describe three SQL queries to provide information to the end users for this system.  At least one must be a join.  These can be real SQL statements or written in English

Table Name

Attribute

Description

Data Type

Null

Keys

Sales

Sales_ID

Contains unique Sales ID

INT

No

Primary key

 

Product_Price

Price of the Product

VARCHAR(30)

No

 
 

Sales_Date

Sales of the Date

VARCHAR(30)

No

 
 

Quantity

Quantity of product

DATE

No

 
 

Personal_ID

Personal_ID ofSales

INT

No

Foreign key

 

Cashier_ID

Cashier_ID of Sales

INT

No

Foreign key

 

 

Table Name

Attribute

Description

Data Type

Null

Keys

Product

Product ID

ID of the Product

INT

No

Primary key

 

Product_name

Name of the Product

VARCHAR(50)

No

 
 

Brand_name

Brand of the name

VARCHAR(50)

No

 
 

Quantity

Quantity

VARCHAR(20)

No

 
 

Pharmaceutical_ID

Pharmaceutical of the ID

INT

No

Foreign Key

           

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Engineering
Computer Science

Relational Databases

Databases

Related Computer Science Q&A

Find answers to questions asked by students like you.

Q: Hello! I am having trouble with my intro to JAVA course. I have basic understanding of it, I am fail...

A: //code: public class DemoProgram {  public static void main(String[] args) {  // TODO Auto-generated...

Q: Clustering is a side effect of linear probing. Group of answer choices True False

A: True

Q: In Python:  So this is part of a large project I am working on but I'm having a hard time finding ou...

A: The ask is to build the study hours application by doing the following: - read the student details f...

Q: (d) create_area_dict(list2D) that takes a 2D-list containing the database as input and creates a dic...

A: def create_area_dict(database):    d={}    for i in range(len(database)):        key=database[i][0] ...

Q: What is the correct way to check whether a variable x is divisible by 3 and divisible by 2 but not d...

A: Answer is : if( (x%3 ==0) && (x%2 ==0) && !(x%5 ==0)) and if( (x%3 ==0) && ...

Q: Subject:Database

A: Objective: A relation R (A,B,C,D,E,F,G,H) is given. We need to convert this functional dependency up...

Q: What is hot potato routing?

A: Hot potato routing Hot potato routing is a routing technique which is used to enable packet routing...

Q: Translate the following c++ code into pep9 assembly language #include using namespace std; int squ...

A: Converted Code:  _ZSt4endlIcSt11char_traitsIcEERSt13basic_ostreamIT_T0_ES6_@plt:  jmpq   *0x2fe2(%ri...

Q: A vector contains the grades obtained by students of a class in an assessment, with the following ch...

A: Declare an integer variable size to hold the capacity of both the vectors.   Declare one float and o...

Q: 4- Please I want solution of this question urgently. Thanks

A: Code: #include <stdio.h>   int main() {     int x,y,z;//declaring variables x,y and z     prin...

Q: Were locations A-M adequate, or did you need a larger sample to find the patterns?

A: Yes

Q: need code in C++ answer all parts Assume the Product structure is declared as follows: struct Produc...

A: I have solved the first 4 parts of the question, please post parts 5 to 7 in a separate post and I w...

Q: python a) There are six quizzes with grades 0 through 10. The lowest grade will be dropped.b) The pr...

A: Actually, python is a easiest programming language. It is a dynamically typed programming language.

Q: Q5: (Count positive and negative numbers and compute the average of numbers) Write a program that  r...

A: Step 1:- Note:-I am writing the program in the java programming language Program Approach:- 1.Declar...

Q: Object is name(age,time) For example : apple (1,11)  the Binary tree order depend on age Write a jav...

A: An object in Java is the physical as well as a logical entity. An object has three characteristics: ...

Q: What would be the output of the following python code?

A: Click to see the answer

Q: Write a program in C++. Program Information You recently visited a clock shop and it started you thi...

A: Actually, c++ is a general language.

Q: The Code must be in Matlab

A: x = input('Input the value of x : ');if(x<1)    y = log(1./(1-x));    disp('Calculated value is :...

Q: Create a pentagon (5 sided polygon) in code blocks

A: Since it is not mentioned here nor the programming language. Following is a code in c++ using graphi...

Q: 5th question A

A: The, answer has given below;

Q: Find the error in each of the following program segments and explain how to correct it "In C" : A) c...

A: Hey, since there are multiple sub-part questions posted, we will answer first three-sub-part questio...

Q: Using an unsorted array to implement a map would allow an O(log2N) get operation (where N is the num...

A: False Loop will run array n times and Second loop again n times Nested Loop

Q: A substring of a string is a contiguous sequence of characters from the string. For example, BC is a...

A: import java.util.*;class Test134 { public static void main(String args[]) {  Scanner sc = new Scanne...

Q: Assume that bit P2.2 is used to control an outdoor light and bit P2.5 a light inside a building. Sho...

A: PROGRAM:   SETB C                   ; CY = 1 ORL C,P2.2            ; CY = P2.2 OR CY MOV P2.2,C     ...

Q: Who in an organization should decide where in the organizational structure the information security ...

A: The first group of people we are going to look at play a role in designing, developing, and building...

Q: Recall the airplane puzzle from the lab: the first person to get on the plane picks a random seat,  ...

A: Actually, given information is: Enter your answer as a decimal number  with at most three digits aft...

Q: Compiler Construction

A: Actually, compiler is a special program that turns the code into machine language.

Q: Why is Burberry's Digital Strategy So Good?

A: Burberry's Digital Strategy is a great way to promote the brand to a key target audience and encoura...

Q: Describe a utility-based agent for an autonomous delivery robot. You must describe thefollowing for ...

A: As per the policy, we can answer only the first three subparts, so answers are below- How the utilit...

Q: A set of ten BCD readings is stored in the ML 2050H. Write an ALP for 8085 to convert the numbers in...

A: Algorithm – Load 00H in a register (for carry) Load content from memory into register pair Move con...

Q: In a python program you can simulate a magic square using a two-dimensional list. Write a function t...

A: #Set the number of NumOfRows and columns NumOfRows = 3 NumOfColumns = 3 MIN = 1 MAX = 9 #Define a fu...

Q: JAVA Please solve Question 4 Please solve Question 4 Please solve Question 4 Please solve Question 4...

A: Actually, java is a object oriented programming language it is platform independent.

Q: Event Listeners Go to the co_credit.js file in your editor. Create an event listener for the window ...

A: Actually, JavaScript is a programming language for the web.

Q: Compare 0-, 1-, 2-, and 3-address machines by writing programs to computeX = (A x B + C) / (D − E × ...

A: //Assemble Language Code 3 Address 2 Address  1 Address(ACCUMULATOR) 0 Address(STACK MACHINE) Loa...

Q: Create a class called Employee that includes four pieces of information as data members — a first na...

A: public class Employee { String fName; String mName; String lName; int mSalary;  public Employee(Stri...

Q: Identify the independent variable(s) and dependent variable(s) of the study. Develop the conceptual ...

A: The, answer has given below;

Q: create the program for a game that simulates rolling two dice by generating two random numbers betwe...

A: Open flowgorithm. Click on the line in between Main and End. Select Output. Double click on Output. ...

Q: Subject: Java My last 5 digit : 03086

A: Programming instructions:   Include the necessary header file. Create a class. In the class, create...

Q: Exercise 3.9Modify program P34_1.cpp to compute the side area, total area, and volume of a cylinder ...

A: The, given information is: Modify program P34_1.cpp to compute the side area, total area, and volume...