MI0034 – Database Management Systems

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

(Prefer mailing. Call in emergency

Assignment

Drive	Semester 2017
Program	Master of Business Administration - MBA
Semester	3
Subject code & name	MI0034  – Database Management Systems
Book ID	B1966
Credit and Max. Marks	4 Credits , 60 Marks

Question 1. Conventional design versus database design.

Answer : The modeling of database applications involves deciding on how to represent the project in real-world objects. The data modeling process corresponds to a set of conceptual tools to describe data, its relationships, its semantics, and constraints of consistency. This process involves the steps related to the identification of requisites, conceptual modeling of data, conventional modeling, and non-conventional modeling of objects, and its relationships.

Question 2. What are the success factors of client–server environment.

Answer : A client/server environment is an environment in which multiple applications connect to Derby over the network. The client–server model is a distributed application structure that partitions tasks or workloads between the providers of a resource or service, called servers, and service requesters, called clients. Often clients and servers communicate over a computer network on separate hardware, but both client and server may reside in the same system. A server host runs one or more server programs which share their resources with clients. A client does not share any of its resources, but requests a server's content or service function. Clients therefore

Question 3. Describe the construction of hard disk drive.

Answer : Hard disks are rigid platters, composed of a substrate and a magnetic medium. Hard disks are rigid platters, composed of a substrate and a magnetic medium. The substrate – the platter’s base material – must be non-magnetic and capable of being machined to a smooth finish. It is made either of aluminum alloy or a mixture of glass and ceramic. To allow data storage, both sides of each platter are coated with a magnetic medium – formerly magnetic oxide, but now,

Question 4. Identify the advantages of client applications.

Answer : An application client is a stand-alone application that runs on the client machine and is configured to work as a J2EE component.

The application client is used to perform tasks, such

Question 5. Explain the basics of OOD.

Answer : Object Oriented Design is the concept that forces programmers to plan out their code in order to have a better flowing program. Object Oriented Design is defined as a programming language that has 5 conceptual tools to aid the programmer. These programs are often more readable than non-object oriented programs, and debugging becomes easier with locality.

These features are often referred to by these common names:

Question 6. Explain kinds of joins are: simple equi-join, self-join, outer

join.

Answer : An SQL join clause combines columns from one or more tables in a relational database. It creates a set that can be saved as a table or used as it is. A JOIN is a means for combining columns from one (self-table) or more tables by using values common to each. ANSI-standard SQL specifies five types of JOIN: INNER, LEFT OUTER, RIGHT OUTER, FULL OUTER and CROSS. As a special case, a table (base table, view, or joined table) can JOIN to itself in a self-join.

Dear students get fully solved assignments

Send your semester & Specialization name to our mail id :

“ help.mbaassignments@gmail.com ”

or

Call us at : 08263069601

(Prefer mailing. Call in emergency