Phone:+91-88823 09876

ignou solved assignment MCS-043 Advanced Database years 2015-16

University:  IGNOU
University: 
IGNOU
Year: 
2015
Subject: 
MCS

Solved assignment is ready kindly make payments and get this assignments

Hand written – Rs 1200/-

Soft copy by email 700/-

Any quries kindly call me 888-2309876 or email solvezone@gmail.com

1.
(a) Design a gennalization and specialization hierarchy for an automobile sales company. The company sells motorcycles, passenger cars, vans and trucks. Justify your placement of attributes at different hierarchy.
(5 Marks)
(b) Write SQL statements for the following:
(i) Grant select on student table to a student Shyam
(ii) Revoke insert, update and delete permission on department table for user Mohan.
(5 Marks)
2.
(a) Explain the followings in the context of XML.
(i) XML Tags
(ii) Document type
(4 Marks)
(b) Create an XML schema for list of their MCA students and their marks of 5th semester course.
(6 Marks)
3.
(a) Explain the role of checkpoints in log based recovery with the help of an example.
(5 Marks)
(b) Define a trigger check-key that does not allow duplicate values in attributes employee no. in employee table.
(5 Marks)
4.
(a) How is clustering and segmentation related to data mining? Explain partitioning clustering algorithms.
(6 Marks)
(b) What are data marts? What is the significance of creating them?
(4 Marks)
5.
(a) How will you enforce referential integrity constraints in Oracle? Explain with the help of one example.
(5 Marks)
(b) Create an object- oriented database using ODL for the following schema. Make suitable assumptions about attributes.
(5 Marks)
Student
Interview
Appears for
for
m
n
8
6.
(a) How does an OLAP support query processing in dataware house?
(4 Marks)
(b) What do you understand by query processing and query optimization? What are query trees and query graphs? Explain with an example of your choice.
(6 Marks)
7.
(a) Explain MVD (multi valued dependency) and join dependency with the help of an example for each.
(5 Marks)
(b) How audit trails is done in database? How are they related to database security?
(5 Marks)
8.
(a) How does oracle manage database security?
(4 Marks)
(b) The organization called XYZ Pvt. Ltd. Company undertakes several kinds of projects. Each employee can move on one or more projects. Each project is undertaken on the request of a client. A client can request for several projects. Each project has only one client. A project can use a number of items from different manufacturers and an item may be used by several projects.
Before the delivery of items to a client, it is tested by a testing group in the organization. Draw E-R diagram and convert it into a relational schema. Also identity primary key in each relation.
(6 Marks

Assignments

Dear Student,

As per your last email you requested a solved assignment which is always available with us. We ensure you that the answer quality would be the best and you will get up to 90% to 100% marks in the assignments purchased from us. We have an expert on every subject working with us. The subject matter experts are highly qualified and deliver their best for you over and over again.

Please have a look at the price list mentioned below and send us a reply on this e-mail to let us know which assignment you want from us.

 

Type A- Rs._ per subject – This assignment is ready to use assignment for every student. (The content of this assignment is the same for every student. You may risk getting your marks deducted by the university due to plagiarism.)

Type B- Rs._ per subject - This assignment is personalized and customized just for you. The answers of this assignment would not be shared with any other student. The content of this assignment would be unique and we will delete it from our database after sending it to you exclusively. (This assignment would have 0% plagiarism)

Type C - Rs._ per Subject-Handwritten Assignment

If you want that your assignment should be written manually rather than being sent to you in a MS Word file or uploaded on the internet then we can do that for you. We will do your assignment manually and every answer would be created just for you. You only have to pay Rs._ per subject for handwritten assignments and we will make sure it gets to you on time every time. We can courier the assignment at your preferred address and you just have to receive it. This assignment will be delivered within a week’s time due to the fact that it needs more time to write down an answer than to type it. This assignment would also help you get around 90% to 100% marks because it would be done by our subject matter experts.

 

Please note that you have to pay us in advance. All payment should be made in INR. As soon as we receive your payment, we will send your Type A assignment within 10 minutes only. If you have opted for Type B, we will send the assignment within 5 hours of receiving your payment. If you have opted for Type C, we will send your assignment within 24 hours of receiving the payment. Type B and Type C assignment submission takes more time because we customize each and every word of the assignment just for you. So we request you to be patient.

Pay Online

Now you can also make the payment online by the below mentioned link. We accept payments through Credit Card, Debit Card and Net Banking too.

Click Here To Make Payment

Pay Offline

You can also pay us via NEFT / RTGS by visiting the nearest branch of your bank.

You can also deposit Cash by visiting the nearest branch of ICICI Bank.

Our process

After you have made the payment please email us your payment details with Assignment Name and Type Preference at solvezone@gmail.com. We will revert asap.

Note: For better response time, kindly use e-mail communication and avoid calling us. Our office timings are 9 AM to 6 PM.

 

Synopsis Projects

Dear student,

After reading your last e-mail, we realized that you need assistance in completing your synopsis. We can create your synopsis as per your subject specialization by using the help of our qualified staff members. Our staff members are experts in every subject and the details of the synopsis package is given below:

·         We will charge only a onetime fee of Rs. and deliver the synopsis with guarantee of approval

·         You will get both synopsis & projects and delivered in a short amount of time

·         Live projects will be done as per your current company’s profile

·         We will provide you with full Viva Support (Oral Examination)

·         We will also attach projects guide resume

Payment process

Pay Online

Now you can also make the payment online by the below mentioned link. We accept payments through Credit Card, Debit Card and Net Banking too.

http://solvezone.in/payments

Pay Offline

You can also pay us via NEFT / RTGS by visiting the nearest branch of your bank .

You can also deposit Cash by visiting the nearest branch of ICICI Bank.

Our process

After you have made the payment please email us your payment details with major subject Name and Type Preference at solvezone@gmail.com. We will revert asap. and we will email you within 3 working days.

Note: For better response time, kindly use e-mail communication and avoid calling us. Our office timings are 9 AM to 6 PM.

Year:  2015
Subject: 
MCS