Answer:
SELECT vendor_number, vendor_name, CONCAT ('street', ' ' , 'city', ' ' , 'state', ' ' , 'zip code') as adress
FROM vendor_directory
ORDER BY vendor_name ASC;
Explanation:
* Suppose <u>vendor_directory</u> is the name of the table from which you extract the data with the SELECT sentence.
Answer:
1) Yes, Publisher relation should have a publisherID primary key.
2) NOT NULL and UNIQUE for the BookID, BranchID, CardNumber and name of the borrower in the Book, Book_Copies, Library_branch, and Borrower relations respectively. The DueDate field of the book_loan relation must be a time constraint. The BookID of the Book relation must be serial number for automatic addition and update of bookid across the database.
Explanation:
The Publisher relation should have primary key publisherID which should replace the publisherName in the Book relation to easily make a join query and attain a third-level database model.
It is a power-saving mode for a computer.
It is a power-saving mode designed for laptops.
Answer:
Using python programming language.
Explanation:
#to define the function write as below
def equal():
#to get the two integers from the user
#The user is asked for input in the code below.
x = int(input("Enter the value for X"))
y= int(input("Enter the value for y"))
if x==0 and y==0:
print("both numbers are ", "0")
elif: x==1 and y==1: #This test if both x and y are 1
print("true")
elif: x==y: #this line test if both values are equal
print("true")
else:
print("False")
equal() #end of the function
Answer:
extension describes a character used to separate items in a text
