Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
he sql query that will return the order number quantity ordered price each and total cost of an order quantity price each from the order details
questiona what are decision support systems and what role do they play in the business environmentb data mining is a knowledge discovery process of
questiona differentiate between the following termsi distributed database vs distributed database management system ii homogeneous distributed
a data warehouse can be defined as a subject-oriented integrated time-variant non-volatile collection of data in support of managements decision
a explain the three types of potential mistake which could occur if concurrency control is not properly enforced in the database system support
a explain briefly the three parts of a relational modelb contrast the following terms with an appropriate examplei stored attribute vs derived
questiona visual basic is governed by an event processor explain the meaning of this phraseb differentiate between an general procedure and event
a what is a sub-queryb what is the difference between a scalar sub-query and a tabular sub-queryc write an equivalent sql statement to get the
express the following queries in sqla write the sql code that will create all the four tables given in the appendix your answer should not
a differentiate between information and data b list and briefly explain five potential benefits of the database approach compared to conventional
a distinguish between lsquodatabase and lsquodatabase management systems dbmsb list and briefly describe five potential benefits of the database
questiona prepare an erd for the scenario given belowb convert the er diagram produced in a above into its physical design you have to choose an
consider the relation schemas as followsworks person name company name salary lives person name street city located incompany name city managers
a software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved these details
convert the following er - diagram entity relationship diagram into a relational database the primary keys are underlined 2160convert the
data mining1what is data mining write data mining applications2explain olap write the benefits of olap3what are the key features of a data
database management systems1explain sql server 2000 architecture with diagram2describe second normal and third normal form3explain about query engine
data warehousing amp mining1what is the concept of knowledge discovery in database2describe the following types of multidimensional data
principles of database1state the following termsadatabase b database management system c entity d attribute e relationship2discuss the three level
data base management system1draw the architecture of mysql and explain about its subsystems briefly2elaborate with the help of an example the concept
oracle amp distributed databases1differentiate between plsql functions and procedures2draw the diagram of logical structure of oracle database and
fundamentals of database management1 explain the concept of foreign key how a foreign key differs from a primary key can the foreign key accept
3 10 points assume that you have been presented with the following relation for the baxter aviation database charters pilot pilot name
assignment 1 data management the questions on this exam are based on the baxter aviation case scenario 1 5 points the
construct a b-tree for the following set of key values 2357111719232931assume that the tree is initial empty and the values are added in ascending