Premium Essay

Data Management

In:

Submitted By funingfn007
Words 374
Pages 2
Assignment 1
Part 1
1B.

Customer (Customer ID, Customer Name, Street Address, City. State. Zip, Phone Number)
Order (Order ID, Order Date, Shipping Date, Sales Manager ID, Customer ID) Order. Customer ID references Customer. Customer ID. Order. Sales Manager ID references Sales Manager. Sales Manager ID.
Order Line (Product No, Order ID, Quantity) Order Line. Product No references Product. Product No. Order Line. Order ID references Order. Order ID.
Sales Manager (Sales Manager ID, Sales Manager Name)
Product (Product No, Description, Unit Price, Manufacturer Name) Product. Manufacturer Name references Manufacturer. Manufacturer Name.
Manufacturer (Manufacturer Name, Product No)

Part 2
2B.

Room (Building ID, Room No)
Lab (Building ID, Room No) Lab. Building ID references Room. Building ID. Lab. Room No references Room. Room No.
Computer (CType ID, Computer Type, Type Description, Processor)
Lab-Computer (CType ID, Building ID, Room No) Lab-Computer. CType ID references Computer. CType ID. Lab-Computer. Building ID references Lab. Building ID. Lab-Computer. Room No references Lab. Room No.
Classroom (Building ID, Room No, Board) Classroom. Building ID references Room. Building ID. Classroom. Room No references Room. Room No.
Media (MType ID, Media Type, Type Description)
Room-Media (Building ID, Room No, MType ID) Room-Media. MType ID references Media. MType ID. Room-Media. Building ID references Room. Building ID. Room-Media. Room No references Room. Room No.
Instructor (Emp ID, Name, Rank, Office phone)
Instructor-Media (Emp ID, MType ID) Instructor-Media. Emp ID references Instructor. Emp ID. Instructor-Media. MType ID references Media. MType ID.
Time slot

Similar Documents

Premium Essay

Data Management

...Data Management Data management is the development, execution and supervision of plans, policies, programs and practices that control, protect, deliver and enhance the value of data and information assets Primary data management functions include: 1. Data Governance Data 2. Data Architecture Management 3. Data Development 4. Database Operations Management 5. Data Security Management 6. Reference & Master Data Management 7. Data Warehousing & Business Intelligence Management 8. Document & Content Management 9. Meta Data Management 10. Data Quality Management Data Management: A Unified Approach Effective , unified Data Management Strategies depends on IT and Business users working together. When teams of IT and business users are formed to guide data management, the results are often positive. “The strategy around data management has to deal with the coordination and collaboration of people, processes and technology.” Collaborative teams enable enterprises to use data and drive improvement in much-needed are such as Empower business teams to run their own reports using data collected by the organization. • Allow the organization to take a data-centric approach to decision making. • Design data management systems to handle a rapid increase in data. • Enable organizations to use their data to its fullest potential. It’s also important that enterprises select the right data management platform to cultivate collaboration and drive the business encompassing...

Words: 614 - Pages: 3

Premium Essay

Data Management

...University Data Management March 18, 2014 Data partitioning is a tool that can help manage the day-to-day needs of an organization. Each organization has unique values that drive business. All organizations have policies and processes that are influenced by their environment and industry. The use of data partitioning can help productivity by recognizing the need to categorize data to tailor unique needs. This approach does require some effort. To transition to a new database approach, organizations need to assess the pros and cons of a database transition. The scale of an organization’s database may be the one factor that drives an adoption of this approach. Data partitioning has been developed to address issues that traditional database queries have created. One main problem that partitioning was created to solve is the performance of database queries. According to Alsultanny (2010), “System performance is one of the problems where a significant amount of query processing time is spent on full scans of large relational tables. Partitioning of the vertical or horizontal partitioning or a combination of both is a reliable way of solving the problem” (p.273). By separating queries into either horizontal or vertical processes, the user can avoid delays and strains on a database. This saves time which can be used to improve the productivity an organization has towards their day-to-day operations. Large-scale databases receive the most benefits from partitioning. Data partitioning...

Words: 1572 - Pages: 7

Premium Essay

Data Management

...Top Data Management Terms to Know Fifteen essential definitions you need to know Fifteen Essential Data Management Terms We know it’s not always easy to keep up-to-date Contents with the latest data management terms. That’s why we have put together the top fifteen terms and definitions that you and your peers need to know. OLAP (online analytical processing) Star schema What is OLAP (online analytical processing) Fact table OLAP (online analytical processing) is computer processing that enables a Big data analytics Data modeling Ad hoc analysis user to easily and selectively extract and view data from different points of view. For example, a user can request that data be analyzed to display a spreadsheet showing all of a company's beach ball products sold in Florida in the month of July, compare revenue figures with those for the same products in September, and then see a comparison of other product sales in Data visualization Extract, transform, load (ETL) Florida in the same time period. To facilitate this kind of analysis, OLAP data is stored in a multidimensional database. Whereas a relational database can be thought of as two-dimensional, a multidimensional database considers each data attribute (such as product, geographic sales region, and time Association rules (in data mining) Relational database period) as a separate "dimension." OLAP software can locate the intersection of dimensions (all products sold in the...

Words: 4616 - Pages: 19

Premium Essay

Data Management

...1. Data dependence Data illustration incorporates with the requisition function. If there is alteration in the Data, then also there is a difference in the application function. Data independence Data depiction incorporates with operation function. If there is a transition in the Data, it won’t cause a shift in the application program. 2. Structured data It is established data which could efficiently be reclaimed and reserved in the databases as well as warehouses. It assign to the substantial case of the user's situation such as phenomenon and development. Unstructured data It consists of combined use of several media data like pictures, sounds, and video clips. Then, it is reserved as the element of the user's field situation 3. Data It is the illustration of articles and episode which are reserved and acknowledged in the system. It persists in a array of form such as numeric, symbols, 3RQ variables, and so on. For example, database in dr's clinic will have information such as patient name, address, diagnosis, symptoms, and phone number. Information These are the refined data which elevates the information of the specific using it. Data are worthless in their current prospective from so it is pre-refined and illustrated as the information to the user 4. Repository It is the rationalised reserved area for data meaning, table, data relationships and other parts of data system. It encloses...

Words: 272 - Pages: 2

Premium Essay

U-Commerce and Data Management

...U-Commerce and Data Management Enterprise Data Management and Administration 02/2013 Abstract This report examines the emergence of U-commerce and the implications on data management it’s faced with. Through research of real cases, the paper will examine how U-commerce has been implemented into the operations of businesses and the roles that it plays. It will also provide basic examples of the four elements which make up U-commerce, Ubiquitous, Universal, Unique, and Unison. The paper will address the importance and growing concern of data management of this technology. Enterprise data has never been more accessible to users and across devices than it is now. Assuring the right data makes it to the right places and people, can be very critical to a business’s operations or decision strategies. With a multitude of devices with various interfaces, U-commerce’s data management stability, and privacy is continuously at risk and monitored. The paper will provide a sound rational for why today’s businesses need to make sure that data management is a top priority, as they move into new phases of outlets for doing business, and share business related information. OUTLINE I. INTRODUCTION II. RECOGNIZING U-COMMERCE A. ELEMENTS i. UBIQUITOUS ii. UNIVERSAL iii. UNIQUE iv. UNISON III. U-COMMERCE DATA MANAGEMENT B. CURRENT STATE OF DATA MANAGEMENT C. CHALLENGES OF DATA PROTECTION ...

Words: 3942 - Pages: 16

Free Essay

Data Management for the Internet of Things

...Data Managment During the course of an ordinary work day I took it upon myself to record all of the instances in which I was required to produce any amount of personalized electronic data. The list not only astounded me, but frightened me as well. My day started at six in the morning with a swipe of my electronic key card at my gym. The data in the key card is attached to my social security number, phone number, address, birthdate, and credit card. On my way home I stopped at a coffee shop and paid with a debit card thereby producing another record of my location at an exact time and date. At home while getting ready for work, I logged into a podcast of my favorite National Public Radio show. My login information is connected to a credit card and all of my personal demographics. The time stamp I left while streaming online radio will most likely be saved on a massive server, available for recall for years on end. As disturbing as this seems, this is only the beginning, as my day to day job requires constant surveillance, both by proximity card, audio and video surveillance. Most people can tell you that if you desire privacy at your workplace, do not pursuit a career in corrections. In one eight hour day, my proximity card, which links to my personnel record, is recorded over fifty times a day. In order to enter or exit any door or hallway, one must swipe their proximity card, which logs the activity into a massive database that is backed up into a cloud server on...

Words: 1968 - Pages: 8

Free Essay

Data Base Management

...1. Data dependence Data illustration incorporates with the requisition function. If there is alteration in the Data, then also there is a difference in the application function. Data independence Data depiction incorporates with operation function. If there is a transition in the Data, it won’t cause a shift in the application program. 2. Structured data It is established data which could efficiently be reclaimed and reserved in the databases as well as warehouses. It assign to the substantial case of the user's situation such as phenomenon and development. Unstructured data It consists of combined use of several media data like pictures, sounds, and video clips. Then, it is reserved as the element of the user's field situation 3. Data It is the illustration of articles and episode which are reserved and acknowledged in the system. It persists in a array of form such as numeric, symbols, 3RQ variables, and so on. For example, database in dr's clinic will have information such as patient name, address, diagnosis, symptoms, and phone number. Information These are the refined data which elevates the information of the specific using it. Data are worthless in their current prospective from so it is pre-refined and illustrated as the information to the user 4. Repository It is the rationalised reserved area for data meaning, table, data relationships and other parts of data system. It encloses...

Words: 689 - Pages: 3

Premium Essay

3rai Data Management

...Activity One Data Management Human resources is the key department in the organization which keeps, maintain, updates the data. There is the number of reasons why organisations collect different types of information. One of them is meeting legal requirements. In order to satisfy legal obligations we collect such as information as hours worked to prove how many hours employees have worked (Working Times Regulations), pay rates to show pay details of the employee (Minimum Wage Act). Eligibility to work in UK is also a legal requirement and organisation need to have evidence of this. All this information enable employer to monitor legislation compliance. Another reason of why organisations collect information is to have a point of reference or to be able to retrieve information whenever it is needed. All information has to be easy reachable and well organized. Planning in organisation depends on information, accurate records helps to make decisions when recruiting, making plans on staff development and training, good records helps to achieve companies goals. Good record keeping can help to make decision on facts, helps to know what happening with sickness, absence levels, holiday, labour turnover, discipline, what training and when is needed for the staff, shows accurate performance and productivity of the employees, helps to decide what staff resources are needed to meet production requirements. Every organisation should keep personal records of their employees, statutory...

Words: 1079 - Pages: 5

Premium Essay

Data Management

...advantages/disadvantages of different types of business structure? Product, Market, Market, and Geographic Structures 10-7 The way an organization’s structure works depends on the choices managers make about: 1. 2. 3. How to group tasks into individual jobs How to group jobs into functions and divisions How to allocate authority and coordinate functions and divisions • Job Design – The process by which managers decide how to divide tasks into specific jobs. – The appropriate division of labor results in an effective and efficient workforce. Used to manage the total organization, the overall pattern of structural components and arrangement . Designing organizational structures is part of organizing, one of the four basic management functions. Planning Defining goals, establishing strategy, and developing subplans to coordinate activities Organizing Determining...

Words: 828 - Pages: 4

Premium Essay

Data Management

...measures, and the contractor will have to submit detailed monthly status reports. The RFP for Mulder simply includes a statement of the type of work to be done, an expected budget limit, and the desired completion date. QUESTIONS 1. What do you think will happen? 2. How do you think the crisis facing Yrisket will affect the Mulder project? The Agentfox project? ENDNOTES 1. It could be argued that Phase D in the electioncampaign project will be extended if the candidate is elected, whereupon the “operation” phase represents the elected official’s full political term—but that would be stretching the analogy! For the Mars rover, however, reducing and interpreting the data that the rover signaled back would likely continue for months or years after the rover has stopped functioning; if analysis and interpretation of data were included in the original system concept for the project, then it would constitute Phase D for the system. 2. Traditionally, the practice of systems engineering has been applied to large-scale, hardware Based on proposals received in response to the RFPs, the managers responsible for Mulder and Agentfoxeachselectacontractor. Unknowntoeither manager is that they select the same contractor, Yrisket Systems. Yrisket is selected for the Mulder project because...

Words: 406 - Pages: 2

Premium Essay

Data Management and Analysis

...Data Management and Analysis Analysis the report, it is clear seen that the Data management and analysis methods used is a quantitative comparative descriptive design. Ford, B. (2010) took very careful steps to maintain the rigor and control of their data collection. The author used a statistic software design. She developed her idea into two representative graphs in which she compared call light usage before initiation of hourly rounding, and call light usage after the initiation of hourly rounding. With is in compliance with the objective described by the hypotheses developed in this study. Hourly rounding improves patient satisfactory score. Narrative descriptive also uses to confirm their finding. For a pilot study, one thinks that the sample size was adequate. A sample made of 51 patients, 29 females, 22 males a long with a randomly selected control group is used for that study. Although the researcher did not explain how the data were entered into the computer one assume that it was entered to promote accuracy and to reduce the possibility and effect of bias. In summary this pilot study shows that Ford, B. (2010) provide evidence to suggest that hourly rounding increase patient outcome with is benefited to nursing practice. The author took time to focus on the significant problem, she explains how the data was collected, and the diagram shows the percentage of error and the frequency of the variable. The study’s strengths and weakness is clearly defined. The author stated...

Words: 356 - Pages: 2

Premium Essay

7000 Data Management

...Create a memo describing your initial analysis of the situation at FAME as it relates to the design of the data base application. Write this as though you are writing a memo to Martin Forondo. Ensure that your memo addresses the following points: a. Your approach to addressing the problem at hand (for example, specify the systems development life cycle or whatever approach you plan on taking). Mr. Forondo, FAME (Forndo Artist Management Excellence) needs technology support to track the contracts of artists, a proposal for contracts to new artists, calendars of artist schedules and the performance shows, etc. In any event, music manager today have to be informed about a lot more things than they used to in the past including music licensing, merchandising, sponsorships, branding, crowdfunding, endorsements, social media, direct-to-fan strategies, and more; and putting together a winning strategy for your artists requires the right information in the right context. You also have to have to figure how to acquire financing, make the right connections, get bookings, break through barriers, enter into strategic alliances and joint ventures, generate income for your artists from multiple sources and get maximum exposure for your artist in an ever-changing music industry landscape. This can be achieved by developing an application for your artist management and managing the artist data in the backend using SQL/DB2 database. The application can be managed by the admin, artist managers,...

Words: 1091 - Pages: 5

Premium Essay

Report on Data Management

...Report on data management: Data Management is essential to an organisation and how we collect store and manage data about our employees needs to be compliant with Legal and Industry requirements Two reasons why the organisation needs to collect HR data: * To prove that our employees are eligible to work in the UK and satisfy Legal requirements * HR data can help us identify sickness trends, monitor diversity, identify training needs etc and helps HR identify areas that need attention. Two types of data that is collected within the organisation and how each supports HR practices * Sickness Absence Data allows us to spot trends by groups, departments, managers etc in order to identify problem areas so we can improve performance, reduce absence levels and Identify any underlying issues in the workplace including where Management training on sickness absence is required. HR can also analyse this data and the costs associated such as Occupational sick pay, SSP, Temporary cover, additional overtime costs as well administrative costs such as fees for Dr’s reports. * Leavers Data helps Identify the rates of turnover and stability in different departments by gender, age, disability, ethnic origin, payscale etc. Data recorded from exit interviews helps Identify and manage a number of problems related to retention and can identify average length of service across different functions. Two methods of storing records and the benefits of each The benefits of Data being...

Words: 745 - Pages: 3

Free Essay

Harnessing Information Management, the Data, and Infrastructure

...Harnessing Information Management, the Data, and Infrastructure Writing Assignment #2 Antwaun Taylor Strayer University CIS 500 Prof. Richard Brown Friday, May 1, 2015 The importance of information management is to gain the maximum benefits from your company's information system, which you would have to exploit all its capacities. Information systems gain their importance by processing the data from company inputs to generate information that is useful for managing your operations. Other duties of management is gathering and distributing information, and information systems can make this process more efficient by allowing managers to communicate rapidly. (Markgraf, 2015) The use of information technology has been an essential part of Wal-Mart's growth. A decade ago Wal-Mart trailed K-Mart, which could negotiate lower wholesale prices due to its size. They created a computerized system that identifies each item sold, that would finds its price in a computerized database, creates an accurate sales receipt for the customer, and stores this item-by-item sales information for use in analyzing sales and reordering inventory. Aside from handling information efficiently, effective use of this information helps Wal-Mart avoid overstocking by learning what merchandise is selling slowly. Aside from handling information efficiently, effective use of this information helps Wal-Mart avoid overstocking by learning what merchandise is selling slowly. Wal-Mart's inventory and distribution...

Words: 1155 - Pages: 5

Premium Essay

Trends in Information Analysis & Data Management

...Information Analysis and Data Management Trends in Information Analysis and Data Management Over the last decade, advancements in digital technology have enabled companies to collect huge amounts of new information. This data is so large in scope, it has traditionally been difficult to process and analyze this information using standard database management systems such as SQL. The commoditization of computer technology has created a new paradigm in which data can be analyzed more efficiently and effectively than ever before. This report analyzes the some of the most important changes that are currently taking place within this new paradigm. The first part of this report covers trends in database analysis by analyzing the field of data mining. The report covers the topic of data mining by providing an explanation of it, and then by providing examples of real-world examples of data mining technology. Benefits and challenges of data mining are then provided. The second part of the report outlines an even more recent trend in data science, which is the increasing usage of noSQL databases to analyze “big data,” also referred to web-scale datasets. The most recent and major technological developments in the industry are then provided and described. Data Mining Background & Definition Data mining involves the process of discovering and extracting new knowledge from the analysis of large data sets. This is most often done through the use of data mining software, which identifies...

Words: 2546 - Pages: 11