CS6302 DATABASE MANAGEMENT SYSTEMS UNIT I 1. What are the disadvantages of file processing system? 2. Explain the basic structure of a relational database with an example. 3. What do you mean by weak entity set? 4. Give example for one to one and one to many relationships. 5. What is the need of normalization? 6. Write a note on functional dependencies. 7. Who is a DBA? What are the responsibilities of a DBA? 8. What is a data model? List the types of data models used. 9. What are the components of
Premium Database SQL Relational model
success as a global player (35 marks) Referencing: citation "Amazon Europe Strategy." 123HelpMe.com. 03 Feb 2013 <http://www.123HelpMe.com/view.asp?id=163597>. INTRODUCTION Amazon.com Inc.‚ is an American multinational company with headquarters in Seattle‚ Washington‚ United States‚ and operating in United States‚ Canada‚ United Kingdom‚ France‚ Germany‚ Austria‚ Italy‚ Spain‚ Brazil‚ Japan‚ and China. Amazon became the world’s largest online retailer which started from the
Premium Strategic management Amazon River Amazon
The Components of System Unit System Unit – a case that contains electronic components of the computer used to process data. Motherboard – the main circuit board of the system unit. Computer Chip – a small piece of semiconducting material usually silicon‚ on which integrated circuits are etched. Processor – interprets and carries out the basic instructions that operate a computer. Multi-care processor – a single chip with two or more separate processor cores. Control Unit – the component of
Premium Universal Serial Bus Flash memory Personal computer
importance of those components which play a major role in supporting the purchase decision of consumers having different mindsets. So present assignment is based on analysis of two important components‚ • Cognitive component. • Affective components. Cognitive component consists of the knowledge and perception that are acquired by a combination of direct experience with the attitude object and related information from various sources. Affective component consists of emotions
Premium Marketing Attitude change Psychology
Mixture that are uniform in composition‚ properties‚ and appearance throughout are called homogeneous. Sugar water is a homogeneous mixture and rocks is a heterogeneous mixture. Homogeneous and heterogeneous mixtures can be separated into their components by several physical methods. The methods that will use for the separation depend on differences in physical properties such as decantation‚ filtration‚ extraction and sublimation. The process of separating a liquid from a solid (sediment) by gently
Premium Mixture Sodium chloride Liquid
Access Case: Dentist’s Office Brief: You will create an Access Relational Database for a dentist’s office. Database Objects: Tables: 1. Patients – keeps a track of patient information (Create at least 7 patients). 2. Dental Procedures – The dentist has 5 procedures. Procedure No. Procedure Type Rate 1 Cleaning Rs.1000.00 2 Crown Rs. 2000.00 3 Filling Rs. 2000.00 4 Root Canal Rs. 3000.00 5 X-Ray Rs. 700.00 3. Appointment – keeps a track of the each appointment‚ Patient‚ Date
Premium Database Relational model Patient
Question 1 Points: 0 out of 10 What is a system unit? a case containing the electronic components of the computer used to process data a device that interprets and carries out the basic instructions used to operate the computer a component of the processor that directs and coordinates most computer operations a circuit board to which many electronic components are attached Feedback Incorrect. The component that directs and coordinates most computer operations is the control unit. Question 2
Premium Personal computer Central processing unit
CIT 214 – Assignment 1 – Logical Database Design‚ The Big Boys and Girls Gym Database View 1 MEMBER (MEM_ID‚ MEM_LAST‚ MEM_FIRST‚ MEM_EMAIL‚ MEM_LEVEL‚ MEM_BDAY) AK MEM_EMAIL SK MEM_LAST EMAIL (EMAIL_ID‚ MEM_ID‚ C_ID‚ EVENT_ID‚ EMAIL_DESCRIP) SK MEM_ID‚ C_ID‚ EVENT_ID FK MEM_ID ( MEMBER FK C_ID ( CLASS FK EVENT_ID ( EVENT CLASS (C_ID‚ C_NUMBER‚ C_NAME‚ C_START_TIME‚ C_END_TIME‚ C_ACTUAL_DATE) SK C_NUMBER EVENT (EVENT_ID‚ EVENT_DESCRIP) SK
Premium Entity-relationship model Social class Relationship
Normalization of Database Tables Database Tables and Normalization * Normalization is a process for assigning attributes to entities. It reduces data redundancies and helps eliminate the data anomalies. * Normalization works through a series of stages called normal forms: * First normal form (1NF) * Second normal form (2NF) * Third normal form (3NF) * Fourth normal form (4NF) * The highest level of normalization is not always desirable. * The Need
Premium Database normalization
t) Operation of individual media 8) 5 Features u) Support diff. multimedia data type v) Handle large no. multimedia obj. w) Hierarchical storage structure & archiving data x) Information-retrieval y) Database capabilities MULTIMEDIA DATA 1. Multimedia data size [Size of media data makes storage‚ processing‚ transmission and reception of the data very costly] a. Multimedia data acquisition * Data
Premium Electronic media Type system Object