DC10 PART-I DATABASE MANAGEMENT SYSTEMS TYPICAL QUESTIONS & ANSWERS OBJECTIVE TYPE QUESTIONS Each question carries 2 marks. Choose the correct or best alternative in the following: Q.1 In the relational modes‚ cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints. Ans: A Q.2 Relational calculus is a (A) Procedural language. (C) Data definition language. Ans: B Q.3 The view of total database content is (A) Conceptual view
Premium SQL Data modeling Relational model
1. Let us design a database for an bank‚ including information about customers and their accounts. Information about a customer includes their name‚ address‚ phone‚ and Social Security number. Accounts have numbers‚ types(e.g.‚ savings‚ checking) and balances. We also need to record the customer(s) who own an account. Draw the E/R diagram for this database. Be sure to include arrows where appropriate‚ to indicate the multiplicity of a relationship. Solution: [pic] 2. For your E/R diagram of
Premium Relational model Florida Keys Relation
study: MBA Course Title: Marketing Research Course code: MBA 763 Assignment: Secondary Data Mat Number: 74168 Name: Abiona Timothy Olufemi What is Data Data is a collection of facts‚ such as numbers‚ words‚ measurements‚ observations or even just descriptions of things. 1.Information in raw or unorganized form (such as alphabets‚ numbers‚ or symbols) that refer to‚ or represent‚ conditions‚ ideas‚ or objects. Data is limitless and present everywhere in the universe. See also information and knowledge
Premium Research
1. Data mart definition A data mart is the access layer of the data warehouse environment that is used to get data out to the users. The data mart is a subset of the data warehouse that is usually oriented to a specific business line or team. Data marts are small slices of the data warehouse. Whereas data warehouses have an enterprise-wide depth‚ the information in data marts pertains to a single department. In some deployments‚ each department or business unit is considered the owner of its data
Premium Data warehouse Data management
Data Preprocessing 3 Today’s real-world databases are highly susceptible to noisy‚ missing‚ and inconsistent data due to their typically huge size (often several gigabytes or more) and their likely origin from multiple‚ heterogenous sources. Low-quality data will lead to low-quality mining results. “How can the data be preprocessed in order to help improve the quality of the data and‚ consequently‚ of the mining results? How can the data be preprocessed so as to improve the efficiency and ease
Premium Data mining Data analysis Data management
Database marketing is the technique of gathering all the information available about customer‚ leads and prospects into a central database and using that information to drive all marketing efforts. The information is stored in a marketing database and can be used at both the strategic and tactical levels to drive targeted marketing efforts. (www.itsallgoodwebdesign.com/html/database_marketing.html). A database is a collection of data arranged for computer retrieval. Marketing can defined as "performance
Premium Sales Customer service Customer
Ex. No.: DATABASE CONNECTIVITY Date: AIM: To Working with VB Forms and Connect the Oracle 10g to Visual Studio 6.0 for Database Connectivity PROCEDURE: Step 1: Start All ProgramsVisual Studio 6.0 Choose Standard Exe Form Step 2: Choose Project In Menubar And Choose The Ado Data Control 6.0 Step 3: Connect The Adodc To Microsoft Oledb Provider For Oracle Step 4: Data Link Properties Type The Username And Password Step 5: Click The Test Connection To Make The Connectivity
Premium Oracle Microsoft
Database Concepts Terminology In general‚ there are many acronyms and a lot of terminology used throughout the entire Information Technology (IT) field that is not used anywhere else. In this paper‚ I will briefly describe the following five terms: Online Analytical Processing (OLAP)‚ Data warehouse‚ data mart‚ three-tier architecture‚ and Active Server Pages. Online Analytical Processing OLAP "On-Line Analytical Processing - A category of applications and technologies for collecting‚ managing
Premium World Wide Web Web server
Data Mining Project – Dogs Race Prediction Motivation Gambling is very popular in the Republic of Ireland‚ weather is online or not‚ more people are joining gambling communities formed all over the Island of Ireland. The majority of these communities are involved in horse races related gambling and other sports‚ but there is a significant amount of people dedicated to dogs races. This is a multimillion Euro industry developed on-line and live or face to face. Objective There are many websites
Premium Race Data analysis Data mining
TYPES OF DATA AND COMPONENTS OF DATA STRUCTURES Data types 1. Primitive: is a data type provided by a programming language as a basic building block 2. Composite: is any data type which can be constructed in a program using its programming language’s primitive data types and other composite types 3. Abstract: is a mathematical model for a certain class of data structures that have similar behavior; or for certain data types of one or more programming languages that have similar semantics
Premium