MySQL
Write relation algebra and SQL expressions:
Supplier(supplier_id, supplier_name, city)
Supplies(supplier_id, part_id, quantity)
Parts(part_id, part_name, color, weight)
Write SQL statement for the following:
Publisher(pid, name, location)
Book(bid, title, author, page, price)
Publish(bid, pid, publish_date)
Write the SQL statement for the following:
Account(acc_number, branch_name, balance)
Depositor(cust_name, acc_number)
Branch(branch_name, city)
DBMS: SQL for Relational Database of a College. Tables: Student, Teachers and College
DBMS SQL Practice Question.
Tables: Users, Categories and Expenses
There are times when you have your project deployed on a server(lets call it Server PR) and MySQL Database on another system(say Server MD). The reason for having this segregation could be performance benefit or something else. Today I wanted to do the same in one of my Drupal project. First I tried by simply changing the host and port number in… continue reading