Search & Filtering
Databases | SQL | Oracle | MS Access
After identifying the entities, attributes, and relationships among the entities of the application, you
need to start with the design of the database. For this, you need to perform the following tasks:
1. Draw an E/R diagram to demonstrate the relationships between the various entities of the
application. [8 Marks]
2. Map the E/R diagram to tables that you need create in order to accomplish the requirements of
the application. [3 Marks]
3. Identify the attributes that can be used as primary keys for the corresponding tables in the
relational database design. [2 Marks]
4. Identify the various schemas that need to be created while designing the database. [2 Marks]
need to start with the design of the database. For this, you need to perform the following tasks:
1. Draw an E/R diagram to demonstrate the relationships between the various entities of the
application. [8 Marks]
2. Map the E/R diagram to tables that you need create in order to accomplish the requirements of
the application. [3 Marks]
3. Identify the attributes that can be used as primary keys for the corresponding tables in the
relational database design. [2 Marks]
4. Identify the various schemas that need to be created while designing the database. [2 Marks]
Databases | SQL | Oracle | MS Access
ShopMart is a leading chain of departmental stores in America. It has many stores in the United
States, Bahamas, Canada, Cuba, Costa Rica, and Mexico, with its head office in California. The
chain is known for quality products, affordable prices, timely service, and a free home-delivery
facility. To ensure customer satisfaction and trust, the store procures the best quality goods from
different countries. In addition, to ensure prompt service, the store maintains an optimum level of
inventory all the time.
ShopMart deals in various categories of products, such as Household, Sports, Accessories, and
Clothing. Currently, the details of all these categories are stored in the ProductCategory file. The
details stored in the file consist of ID, name, and description of the categories. In addition, the
details of all the products are stored in the ItemDetails file. The details stored in this file consist of
ID, name, description, category ID, and unit price of the products. In addition, the ItemDetails file
stores i
States, Bahamas, Canada, Cuba, Costa Rica, and Mexico, with its head office in California. The
chain is known for quality products, affordable prices, timely service, and a free home-delivery
facility. To ensure customer satisfaction and trust, the store procures the best quality goods from
different countries. In addition, to ensure prompt service, the store maintains an optimum level of
inventory all the time.
ShopMart deals in various categories of products, such as Household, Sports, Accessories, and
Clothing. Currently, the details of all these categories are stored in the ProductCategory file. The
details stored in the file consist of ID, name, and description of the categories. In addition, the
details of all the products are stored in the ItemDetails file. The details stored in this file consist of
ID, name, description, category ID, and unit price of the products. In addition, the ItemDetails file
stores i
Databases | SQL | Oracle | MS Access
Perform the following tasks to create the database required for the application:
Create a database for the application.
Create the required schemas in the database.
Create the required tables under each of the schemas.
Populate the tables with sample data.
Create a database for the application.
Create the required schemas in the database.
Create the required tables under each of the schemas.
Populate the tables with sample data.
Databases | SQL | Oracle | MS Access
Q1) What are the new features in MySQL 5.1?
Q2) Explain all the date and time functions in MySQL.
Q3) Describe the cursors in MySQL in detail.
Q4) Briefly describe the error log and general query log in MySQL.
please send me the answer of these four question in 400 word. har question ka answer 400 word me answer dijiye please...
Q2) Explain all the date and time functions in MySQL.
Q3) Describe the cursors in MySQL in detail.
Q4) Briefly describe the error log and general query log in MySQL.
please send me the answer of these four question in 400 word. har question ka answer 400 word me answer dijiye please...
Databases | SQL | Oracle | MS Access
I need this done in php and mysql- need at system of forms to be used to both query and update a database. The database is already available -I just need the php part .. I even have a template to use as teacher gave us an example to base the work on.
It's due in 2 weeks.
Quote?
It's due in 2 weeks.
Quote?
Databases | SQL | Oracle | MS Access
. An insurance database has the tables given below. The data types are also specfified.
Table name : owner_details
Column name Format
Owner_id Char(4)
Name Varchar(25)
Address Varchar(40)
Table name : car
Column name Format
Reg_no Char(10)
Model Varchar(15)
Year Number(4)
Table name : accident
Column name Format
Report_no Number(5)
Acc_date Date
Location Varchar(20)
Table name : cars_owners
Column name Format
Owner_id Char(4)
Reg_no Char(10)
Table name : cars_in_accident
Column name Format
Owner_id Char(4)
Reg_no Char(10)
Report_no Number(5)
Cost_of_damage Number(5)
a) Create the above table with proper primary and foreign keys.
b) Enter at least 5 tuples for each relation
c) Update the cost of damage for a particular car involved in an accident with report
number 25 to 30000.
d) Add a new car to the database
e) Add a new accident to the database
f) List the car owners whose cars were involved in accidents in the year 2006
g) Find the number of
Table name : owner_details
Column name Format
Owner_id Char(4)
Name Varchar(25)
Address Varchar(40)
Table name : car
Column name Format
Reg_no Char(10)
Model Varchar(15)
Year Number(4)
Table name : accident
Column name Format
Report_no Number(5)
Acc_date Date
Location Varchar(20)
Table name : cars_owners
Column name Format
Owner_id Char(4)
Reg_no Char(10)
Table name : cars_in_accident
Column name Format
Owner_id Char(4)
Reg_no Char(10)
Report_no Number(5)
Cost_of_damage Number(5)
a) Create the above table with proper primary and foreign keys.
b) Enter at least 5 tuples for each relation
c) Update the cost of damage for a particular car involved in an accident with report
number 25 to 30000.
d) Add a new car to the database
e) Add a new accident to the database
f) List the car owners whose cars were involved in accidents in the year 2006
g) Find the number of
Databases | SQL | Oracle | MS Access
A software company has the following information about its clients and the projects given by them:
Clients (client number, client name, address)
Projects(project number, project name, total investment, no. of people working on the project)
Client project(client number, project number, date of start of project)
Create a database with the tables given above. Give suitable field names, keys and validation checks. Create data entry forms and enter at least 10 rows.
Run the following queries on the above database:
a) List clients who have assigned more than 2 projects to the software company.
b) List clients in order of decreasing total project investment.
c) Show the details of the project with the maximum number of people working on the it.
Clients (client number, client name, address)
Projects(project number, project name, total investment, no. of people working on the project)
Client project(client number, project number, date of start of project)
Create a database with the tables given above. Give suitable field names, keys and validation checks. Create data entry forms and enter at least 10 rows.
Run the following queries on the above database:
a) List clients who have assigned more than 2 projects to the software company.
b) List clients in order of decreasing total project investment.
c) Show the details of the project with the maximum number of people working on the it.
Databases | SQL | Oracle | MS Access
An SQL query to calculate the average amount of invoices for each customer, sorted in ascending order.
Databases | SQL | Oracle | MS Access
For the follow tables:
create table customer(
cid integer, --- customer ID
cname varchar(50), --- customer name
primary key (cid));
create table product(
pid integer, --- product ID
pname varchar(50), ---- Product name
price number, --- price of product
primary key (pid));
create table orders(
oid integer, --- order ID
cid integer,--- customer ID
primary key (oid),
foreign key (cid) references customer(cid));
create table order_line(
oid integer, --- order ID
pid integer, --- product ID
quantity integer, --- quantity of product in the order
primary key (oid, pid),
foreign key (oid) references orders(oid),
foreign key (pid) references product(pid));
Write a PL/SQL procedure to print out the names of customers who have bought a certain product. The product name is the input parameter
create table customer(
cid integer, --- customer ID
cname varchar(50), --- customer name
primary key (cid));
create table product(
pid integer, --- product ID
pname varchar(50), ---- Product name
price number, --- price of product
primary key (pid));
create table orders(
oid integer, --- order ID
cid integer,--- customer ID
primary key (oid),
foreign key (cid) references customer(cid));
create table order_line(
oid integer, --- order ID
pid integer, --- product ID
quantity integer, --- quantity of product in the order
primary key (oid, pid),
foreign key (oid) references orders(oid),
foreign key (pid) references product(pid));
Write a PL/SQL procedure to print out the names of customers who have bought a certain product. The product name is the input parameter
Databases | SQL | Oracle | MS Access
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.
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.
