EE4791 Database Systems 2012-13 Project (CA‚ 20%) Design and Implementation of the Database with Microsoft Access. Group assignment (1-3 persons per group): 1. Propose a database Case Study with at least 5 tables. Write down the requirements on the database. 2. Draw EER diagram. 3. Give relational model (i.e.‚ logical scheme). Normalize up to 3NF. 4. Create the tables in MS Access in Design View. Choose indexes for your query. Implement data integrity (default value‚ range values‚ etc) 5. Implement
Premium Microsoft Access SQL Microsoft
USING INFORMATION TECHNOLOGY TO IMPROVE FOOD SERVICE SUBMITTED BY: VICTORIA BERAHMANDPOUR PROFESSOR: PATRICK DEELY IS535 DATE: 12/15/12 Table of Contents Abstract 3 Brief Company background 4 Discussion of business problem(s) 5 High level solution 6 Benefits of solving the problem 7 Business/technical approach 8 Business process changes 9
Premium Darden Restaurants Red Lobster
Understanding technology is important when managing companies that have computer technology as their backbone. Knowing this information helps the employees responsible for information management to make informed choices about how to implement technology. These decisions allow the manager to successfully use time and resources in apparently menacing tasks. This is shown in the two scenarios. In the first scenario‚ a marketing assistant of a consumer electronics company is given the task of maintain
Premium Computer network Wi-Fi
Expert Systems with Applications 37 (2010) 5259–5264 Contents lists available at ScienceDirect Expert Systems with Applications journal homepage: www.elsevier.com/locate/eswa Cluster analysis using data mining approach to develop CRM methodology to assess the customer loyalty Seyed Mohammad Seyed Hosseini *‚ Anahita Maleki‚ Mohammad Reza Gholamian Industrial Engineering Department‚ Iran University of Science and Technology‚ Tehran‚ Iran a r t i c l e i n f o a b s t r a c t
Premium Marketing Customer relationship management
of exploration data E very year explorationists‚ industrywide‚ collect billions of dollars worth of data. Yet‚ when it comes time for geologists to extract value from their information‚ they often find that value has been lost through poor practices in data management. There is no reliable record of the data that has been collected or data is not where it should be - it has been misplaced or corrupted. Re-assembling information can consume weeks of their time and can dramatically reduce
Premium Rio Tinto Group Mining Data
Week 3 Determining Databases and Data CommunicationsBIS 320 Week 3 Determining Databases and Data CommunicationsScenario 1: If I were a marketing assistant for a consumer electronic company and I had to set-up my company’s booth at the tradeshow. I would be need to be extremely detailed in packing up equipment and components. The cost of this technology is extremely expensive and it is my responsibility and my job on the line. When technology companies do tradeshows there are a wide variety of equipment
Premium Decision support system Microsoft Excel Decision theory
question # 10 a) Advantages of a database over the instructor’s current system would be; organization of data into one location rather than across several spreadsheets‚ and ease and speed regarding both data storage and retrieval. b) Major topics of the database include; students‚ dates attended‚ assignment and test scores‚ and overall grades. c) A statement of work for this database may look like the following; History: Historically‚ student data has been saved across spreadsheets
Premium Student
DATABASE SPECIFICATIONS Huffman Fleet Truck Maintenance Team A May‚ 2009 Revision Sheet Release No. Date Revision Description 1 5/2/09 Initial creation of document - Kramer 3 5/3/09 Addition of POC and Abbreviations - McCoy 4 5/4/09 Schema - section 2.5.1 DATABASE SPECIFICATIONS TABLE OF CONTENTS Page # 1.0 GENERAL INFORMATION 2 1.1 Purpose 2 1.2 Scope 2 1.3 System Overview 1 1.4 Project References 1 1.5 Acronyms and Abbreviations 1 1.6 Points of Contact
Premium Entity-relationship model
ECO FRIENDLY DATABASE Varun Chauhan MBA Student‚ Delhi Institute of Advanced Studies Pranav Kharbanda MBA Student‚ Delhi Institute of Advanced Studies Vindhya Chhabra B.Tech Student‚ Delhi Technical University (IT) Sumit Jain MBA Student‚ Delhi Institute of Advanced Studies ECO FRIENDLY DATABASE ABSTRACT 2. GREEN DATABASE Database should utilize several modern hardware capabilities. The purpose
Premium Database management system Database Central processing unit
Determining Databases and Data Communications BIS 320 University of Phoenix Instructor: Cornell Perry In this paper the writer will seek to respond to the questions designated for both scenarios. This paper will list typical fields for each type of data. Provide an example of two relationships that you need to track. This paper will also answer the questions of: Do you need a database system? If not‚ can Excel® handle the data and the output? What are the advantages and disadvantages
Premium Computer network Decision support system Decision theory