Databases | SQL | Oracle | MS Access Answers

Create a database named MyCustomers, with the following tables using MySQL. Use
the appropriate data types and note that the underlined fields denotes a field to be
either a primary key or a foreign key
Customers (CustomerID, Name, Address, City)
Orders (OrderID, CustomerID, Amount, Date)
Insert at least 5 records in each of the tables appropriately.

IMPLEMENT USING PHP/MYSQL

a) Create a database and some tables
b) Insert Some Values into Table
c) Update particular field
d) Select all or specific values from the table and display using Web Browser
e) Alter the table name
f) Delete the table from the database

Consider the relations
EMPLOYEE(emp#, name)
5+5
10
ASSIGNED_TO(project#, emp#)
PROJECT(project#, project_name, chief)
Express the following queries in Relational Algebra
(i) Get details of employee working on both comp354 and comp345 project numbers.
(ii)Find the employee number of employee who do not work on project comp678

Is it possible that date stored in database table change automatically ???

What do you mean by anamoly in database system? Why it is required? Explain the types of anamolies in database system.

what is an entity

1) Fetch all the customers that are not from region 'BC' or 'SP'
2 Show all customer contact names and titles for the business owners who are from Germany or France
3 Fetch customers from Germany, Mexico and Sweden
4 Display customers that are from Switzerland but not from city Bern
5 Display total amount by Order ID
6 Count the number of products by Category ID
7 Count the number of products by Category ID and Discontinued status
8 Count the number of products by Supplier ID and Category ID
9 Count the number of products that need to be re-ordered
10 Count the number of products by category ID that are sold in bottles

I have three table



CMS_MenuMaster

ID MenuName MenuDesc ParentID DisplayOrder

1 Product -- 0 1

2 ABC -- 1 2

3 DEF -- 1 3

4 Home -- 0 2

5 Service -- 0 3


EE_RightMaster

RightID RightCode RightDesc

1 Product 1

2 Home 4

3 Service 5

EE_GroupRights

GroupRightID GroupID RightID
1 3 1




Create Procedure SpGetAllMenus
@GroupID int
as
begin
select t3.ID, t3.MenuName, t3.DisplayOrder, t3.Disable, t3.MenuDesc,t3.ParentID,
(select IsNull(MenuName,'') from CMS_MenuMaster where ID = t3.ParentID) as ParentMenu,
from EE_GroupRights t1
inner join EE_RightMaster t2 on t1.RightID = t2.RightID
inner join CMS_MenuMaster t3 on t3.ID = cast(t2.RightDesc as int)
where t1.GroupID = @GroupID
end


for groupid 3 it giv

I am trying to update a field in MySql:

the basic premis is:

FIeld X = Field Y + 30 (both X and Y are numeric)

Both fields are in the same table.

I tried update <tablename> set X = (Y+30) where condition = Z

I then tried update <tablename> set X = sum (Y+30) where condition = Z

both failed. Can you help?

Design an Entity-Relationship Diagram (ERD) for the following database required
by ‘Chan Furniture’ company with the following details:

1. The company sells a number of different furniture products.
The identifier for a product is Product_ID Other attributes for product include Product_Description, Product_Finish, and Unit_Price.

2. Orders must be submitted in order to request for the products
The identifier for an order is Order_ID, and another attribute is Order_Date. An order must consist of at least one product. Any product sold by Chan may not be requested on any order, or may be requested on one or more orders. An attribute associated with each order and product is Quantity, which is the number of units requested.

3. A customer may submit any number of orders, but need not submit any orders.
Each order is submitted by exactly one customer. The identifier for a customer is Customer_ID. Other attributes include Customer_Name and Customer_Address.