Premium Essay

Data Modelling

In:

Submitted By Aleck
Words 1326
Pages 6
1. What is an entity super type, and why is it used?
It is an entity with 1 or more subtypes. It contains common characteristics. It is used to take advantage of inheritance, constraints, discriminators, and reduce the number of nulls. 2. What kinds of data would you store in an entity subtype?
Entity subtypes contain more unique characteristics. A subtype will contain that data that is specific to the entity. Ex. A super type entity named Student contains a field for degrees studying but there could be multiple subtype entities for each different degrees and they would contain that which pertains to that certain degree. 3. What is a specialization hierarchy?
It is an arrangement that has a super type entity that branches into one or more subtype or child entity. 4. What is a subtype discriminator? Give an example of its use.
Attribute in the super type entity that determines to which subtype each super type occurrence is related.
Subtype discriminator may be based on other comparison condition
Flight Hours (>1,500 or <=1,500) 5. What is an overlapping subtype? Give an example.
It is a subtype that contains non-unique subsets of the super type entity set. E.g. an employee can be both an Administrator and a teacher. 6. What is the difference between partial completeness and total completeness?
Partial completeness is when a super-type does not need to use one of the subtypes, whereas total completeness must use at least one. Partial example: an employee can be a student or teacher, but doesn't have to be. Total example: A student must be either a graduate or an undergrad. 7. List all of the attributes of a movie.
Prod_num, prod_title, prod_releasedate, prod price, prod_type, movie_rating, movie_director 8. According to the data model, is it required that every entity instance in the PRODUCT table be associated with an entity

Similar Documents

Free Essay

Modelling Football Data

...Modelling Football Data By Renzo Galea A Dissertation Submitted in Partial Fulfilment of the Requirements For the Degree of Bachelor of Science (Honours) Statistics and Operations Research as main area DEPARTMENT OF STATISTICS AND OPERATIONS RESEARCH FACULTY OF SCIENCE UNIVERSITY OF MALTA MAY 2011 Declaration of Authorship I, Renzo Galea 25889G, declare that this dissertation entitled: “Modelling Football Data”, and the work presented in it is my own. I confirm that: (1) This work is carried out under the auspices of the Department of Statistics and Operations Research as part fulfillment of the requirements of the Bachelor of Science (Hons.) course. (2) Where any part of this dissertation has previously been submitted for a degree or any other qualification at this university or any other institution, this has been clearly stated. (3) Where I have used or consulted the published work of others, this is always clearly attributed. (4) Where I have quoted from the works of others, the source is always given. With the exception of such quotations, this dissertation is entirely my own work. (5) I have acknowledged all sources used for the purpose of this work. Signature: _______________________ Date: _______________________ Abstract Renzo Galea, B.Sc. (Hons.) Department of Statistics & Operations Research May 2011 University of Malta The main goal of this dissertation is to investigate the Bayesian modelling performance for ...

Words: 15822 - Pages: 64

Premium Essay

System Modeling

...System Modeling Margaret Francies Strayer University Term Paper System Modeling Theory– CIS 331 Richard Guirguis Due on 12/8/2010 System Modeling Systems modeling or systems modelling is the approach to the study of the use of models to imagine and construct systems in business and IT development. In business and IT development the term "systems modeling" has multiple meaning. System Modeling can refer to analysis and design efforts, simulation and or system dynamics, and a study of the many uses of these models. There are different approaches to modeling: Agent based data and mathematical modeling. Quality management adopts a number of management principles that can be used by top management to guide their organizations towards improved performance. Principles such as: customer focus, leadership, people’s involvement, the process, system approach to management, continual improvement, facts, and a mutual benefit. . Decision making is a reasoning or emotional process which can be rational or irrational. The cognitive perspective is that the decision making process must be regarded as a continuous process integrated in the interaction with the environment. From a normative perspective, the analysis of individual decisions is concerned with the logic of decision making and rationality and the invariant choice it leads to it can be based on explicit assumptions or tacit assumptions. In decision making, objectives must be established and placed in the order of...

Words: 662 - Pages: 3

Free Essay

An Experimental Comparison of Er and Uml Class Diagrams for Data Modelling

...Empir Software Eng (2010) 15:455–492 DOI 10.1007/s10664-009-9127-7 An experimental comparison of ER and UML class diagrams for data modelling Andrea De Lucia · Carmine Gravino · Rocco Oliveto · Genoveffa Tortora Published online: 11 December 2009 © Springer Science+Business Media, LLC 2009 Editor: Erik Arisholm Abstract We present the results of three sets of controlled experiments aimed at analysing whether UML class diagrams are more comprehensible than ER diagrams during data models maintenance. In particular, we considered the support given by the two notations in the comprehension and interpretation of data models, comprehension of the change to perform to meet a change request, and detection of defects contained in a data model. The experiments involved university students with different levels of ability and experience. The results demonstrate that using UML class diagrams subjects achieved better comprehension levels. With regard to the support given by the two notations during maintenance activities the results demonstrate that the two notations give the same support, while in general UML class diagrams provide a better support with respect to ER diagrams during verification activities. Keywords Controlled experiments · Entity-relation diagrams · UML class diagrams · Design notations · Comprehension · Maintenance · Verification The work described in this paper is supported by the project METAMORPHOS (MEthods and Tools for migrAting software systeMs towards...

Words: 16567 - Pages: 67

Premium Essay

Test

...Business Intelligence Journal The Evolution of Information Management By Don Hatcher, Bill Prentice Customers today are demanding better service, lower prices, and higher quality goods. With such a volatile economy in recent years and with so many businesses competing for the same customers, it is imperative for companies to continually improve their customer service or else risk falling victim to their competitors. This is one reason why many organizations are rethinking how they do business. For years, they have accumulated valuable information as a by-product of production while failing to put it to good use. When a company knows its customers’ buying patterns, interests, and demographics, it provides a distinct competitive advantage. This knowledge has become so critical in recent years that the process of managing information has become an industry of its own. How does a company manage its strategic information assets in today’s rapidly changing business environment? What challenges arise out of that task? Are there any preventive measures that can ease the “growing pains” associated with moving from one information paradigm to the next? No matter how simple or convoluted the current information architecture is, evolving companies’ effective use of information can help them achieve a level of sustainable competitive advantage that can be measured on the bottom line. [pic] Figure 1. The Information Evolution Model and its Five Levels The Information Evolution...

Words: 3863 - Pages: 16

Premium Essay

It Planning

...Strategic Planning for eServices1 A Short Tutorial for the Beginners2 Amjad Umar, Ph.D. Senior Technical Advisor, United Nations-GAID Executive Summary Strategic planning of ICT (Information and Communication Technologies)-based services, abbreviated as eServices, is a crucial task for the public as well as private sectors. Given a strategic project (or an initiative), a strategic planning process identifies the main alternatives, the key business/technical issues involved in each alternative, and helps in evaluation and selection of the most viable alternatives before initiating the project. To succeed, the strategic planning process must explore a large number of people, process and technology issues and eliminate surprises. This is not easy because the task of eservices planning in the digital age is considerably complicated due to the changing business and technical landscape and an ever-growing body of knowledge. This short tutorial gives a quick overview of the vast body of knowledge that entails a typical strategic ICT planning process and presents a conceptual framework for further exploration of this important area. 1. An Example – eServices for a City Ms Fran Kuye is mayor of a city with one million inhabitants, located in a developing country.She wants to use the knowledge gained from her MPA (Master of Public Administration) to transform her city to a “Digital City” that heavily relies on eservices to support its citizens. Her overall goal is...

Words: 5384 - Pages: 22

Premium Essay

Abb Case

...ABB Electric Segmentation - Group Case Analysis Team Members: Emeka Ejika John Marceaux Brandon McNabb Todd Teepell Brandon Woods Suppose you are the regional sales manager for ABB Electric, and you have been given a budget for a supplementary direct marketing campaign aimed at 20% of the companies in your region 1. At present, you have information on the Descriptor Data Tab of the ABB Electric Data (Customer Choice).xls spreadsheet about the location of customers (districts 1, 2, and 3) and the sales potential of each account of prospect. Based on this information alone, to what companies would you direct the new direct marketing program? Specify the accounts and customer or prospect types. In order to determine which potential customers to target with a direct marketing campaign we first searched the ‘ABB Descriptor Data’ and identified Customers that we are currently serving to quantify ABB’s market penetration in each District. We then sorted the remaining Customers (Competitor’s clients) by Annual Purchase Volume as it is the only quantifiable metric provided. Next we cross-referenced that with our market penetration in each District. While ABB’s penetration is deepest in District 1 relative to number of customers serviced, District 2 provides the largest source of Annual Purchase Volume by a margin of three times the next closest District (D3). This extreme disparity is the result of one customer with a very large Annual Purchase Volume that is over seventeen...

Words: 1981 - Pages: 8

Premium Essay

Acc621

...The two risks involved with outsourcing a business process (the off-shore ministry of health) 1. Does the outsourced vendor have adequate internal controls in place 2. Is the outsourced vendor able to provide the same or better quality of the product or service that could be achieved by keeping the business process in house. Three recommendations for the two above risks 1. Ensure there are means of monitoring the effectiveness of the outsourced business process 2. Obtain assurance that the internal controls imbedded in the outsourced business process are operating effectively, through internal audits or external reviews of these controls. 3. Periodically Re-evaluate whether the business case for outsourcing the process remains valid. Limitations of Internal control (5 examples) 1. Human judgment is not perfect(subject to bias) 2. Breakdowns can occur because of errors or mistakes 3. Controls can be circumvented by collusion (two or more people) 4. Management can override controls 5. Controls must be cost effective (costs versus benefits)/ 6. External events outside the organizations control. Why is important from a governance prospective to have an outside director on the Board of Directors. 1) Management receives direct compensation for their work and makes decisions that benefit the short run instead of shareholders long term goals. Having independent directors who don’t receive direct compensation but receive...

Words: 725 - Pages: 3

Free Essay

Promissory Estoppel

...Promissory Estoppel Brian McDonald and Harry Ledman are co-workers at Food mart. They both love model trains and have them as a hobby. While having a casual discussion about the model trains, Brian tells Harry that after he retires he wants to sell his trains and travel. Brian mentions to Harry, “You are the only person I plan to offer my trains to, because I know that you would take care of them.” This statement set the stage for a verbal contract with a pending date of sale, the date of sale being Brian’s retirement. Harry made plans to purchase the train station by saving money, borrowing money and adding on to his home to prepare for the train set. Brian was aware of all the plans that Harry was making. Upon Brian’s retirement he told the train set to his neighbor, James. Harry sued Brian, claiming breach of contract, or in the alternative, for promissory estoppel. Harry’s claims of promissory estoppel are based on the grounds that a promisor (Brian) made a gratuitous promise (to sell his train set) to a promise (Harry). Harry relied on the promise and made purchases to the fact. Brian was aware of all the purchases that Harry was making and he never said anything to Harry to suggest that he had changed his mind. Harry will ask the judge for compensation for all he spent preparing for the train set, the cost of building a 2,000 sq. ft. addition to his home and the loan from aunt Ida the 2,000 square foot room that Harry built for the model train collection and the...

Words: 438 - Pages: 2

Premium Essay

Marketing

...within Microsoft Excel and only with data contained in an Excel spreadsheet. After installing the software, simply open Microsoft Excel. A new menu appears, called “ME XL.” This tutorial refers to the “ME XL/Customer Choice (Logit)” submenu. Overview The customer choice (logit) model is an individual-level response model that helps analyze and explain the choices individual customers make in a market. The customer choice model helps firms understand the extent to which factors such as the price of a brand or its ease of installation influence a customer's choice. A brand's purchase probability at the individual level can be aggregated to determine the brand's market share at the market level. Firms also can use customer choice analysis to develop marketing programs tailored to specific market segments, or even to individual customers. Further, if a company has purchase data about its products versus those of its competitors (product choice data), as well as some observed independent variables (e.g., gender, price, promotion), it can use customer choice modeling to answer such questions as: Does a customer’s gender influence his or her purchase decision regarding our product(s)? Do competitor’s promotions affect the purchase of our product(s)? How do our promotions affect our sales rates? CUSTOMER CHOICE (LOGIT) TUTORIAL – V130522 1/15 Getting Started Customer choice analysis allows you to use your own data directly or to use a preformatted template...

Words: 2855 - Pages: 12

Free Essay

Understanding How Big Data and Crowd Movements Will Shape the Cities of Tomorrow

...1 UNDERSTANDING HOW BIG DATA AND CROWD MOVEMENTS WILL SHAPE THE CITIES OF TOMORROW Andrew Leeson Pablo Alvarez Samya Ghosh AECOM UK 1. INTRODUCTION 1.1 A brief history of crowd modelling. From direct observations to simulation In 1895, the French social psychologist Gustave Le Bon wrote “The age we are about to enter, will truly be the Era of crowds” in his book “The Crowd: A Study of the Popular Mind” (Psychologie des Foules in French). If we take the 8am train to go to work, if we walk through a popular street on a Saturday, or if we go to a big event, we can see Le Bon’s words as a prophecy that describes the world in which we live. Pedestrian planning and crowd modelling have became more important in the last decades, mainly due to the increase in the number of big events that are organised and the accidents that sometimes happen during these events (Evers, 2011). Nowadays, architects, engineers, transport planners and event organisers make use of advanced software and mathematical models to predict the way in which pedestrians will move through train stations, streets, buildings, or stadia in order to create safe and efficient environments. In parallel to them, researchers and scientists are developing new algorithms and tools to improve the accuracy of the predictions. However, the first studies in this field were just based on direct observations, and they set the starting point for further research. According to Baer (1974), a good part of...

Words: 5676 - Pages: 23

Premium Essay

Project Management

...their investigation and Data Analyzing of the current business processes that have concurrently been in progress at Star plus Manufacturing Inc. Through our Time Spend at Star plus manufacturing Inc., we have conducted the following Business Analytics including but not limited too; Analyzing Qualitative Data, Analytics, Business Intelligence, Test and Learn, Business Processes, Statistics and Customer Dynamics. While Analyzing Qualitative Data; we have conducted Open-ended Questions, accepted written comments on questionnaires in order to generate Single word opinions, Brief Outlooks on company environment. We have also found some finding though daily business observations. During our Analytics practices, we have been able to develop optimal or realistic decision recommendations based on insights derived through the application of statistical models and analysis against existing and/or simulated future data. Business intelligence used a well-established process in guiding organizational change through using Computer-Based Techniques to identify, extract and analyze business data, such as Sales revenue by individual departments and products by each ones associated Costs and Income. Test and Learn methods in order to define the impact that, current strategies are impacting customers and clientele. Business Process in order to construct a representation of your current business processes. Statistic information used to find the Mean or median to calculate data information. Customer...

Words: 521 - Pages: 3

Free Essay

Estimating Vehicle Speed from Traffic Count and Occupancy Data

...Journal of Data Science 2(2004), 231-244 Estimating Vehicle Speed from Traffic Count and Occupancy Data Martin L. Hazelton University of Western Australia Abstract: Automatic vehicle detectors are now common on road systems across the world. Many of these detectors are based on single inductive loops, from which data on traffic volumes (i.e. vehicle counts) and occupancy (i.e. proportion of time during which the loop is occupied) are available for 20 or 30 second observational periods. However, for the purposes of traffic management it is frequently useful to have data on (mean) vehicle speeds, but this is not directly available from single loop detectors. While detector occupancy is related in a simple fashion to vehicle speed and length, the latter variable is not measured on the vehicles that pass. In this paper a new method for speed estimation from traffic count and occupancy data is proposed. By assuming a simple random walk model for successive vehicle speeds an MCMC approach to speed estimation can be applied, in which missing vehicle lengths are sampled from an exogenous data set. Unlike earlier estimation methods, measurement error in occupancy data is explicitly modelled. The proposed methodology is applied to traffic flow data from Interstate 5 near Seattle, during a weekday morning. The efficacy of the estimation scheme is examined by comparing the estimates with independently collected vehicle speed data. The results are encouraging. Key words: Bayesian inference, inductance...

Words: 4518 - Pages: 19

Premium Essay

Dt2503 Unit 3 Assignment

...Student ID: 0319297 0319226 0319826 No. Title Page 1 Cover Page 1 2 Table Content 2 3 Question 1 3-7 4 Question 2 8 5 Question 3 9 6 Question 4 10-11 7 References 12 Database Question 1: Data Model/Database Model Flat file Flat file data model is model where data was store as a plain text file in a single table. Each line of the table hold each record with field and it is separated by commas or tabs. It cannot contain multiple tables like relational database. All the data stored by flat file, a computer file system will be store in a single...

Words: 2185 - Pages: 9

Free Essay

Bcbgcbc

...Introduction to Matlab[1] MATLAB( is a computer program by MathWorks, Inc. for people doing numerical computation. Matlab handles numerical calculations and high-quality graphics, provides a convenient interface to built-in state-of-the-art subroutine libraries, and incorporates a high-level programming language. The purpose of this document is to introduce you to some of the basic capabilities of Matlab which you will find useful for a range of data analysis, plotting, or modelling applications. You will learn to work with Matlab by solving a series of exercises to read, analyse and plot a variety of micrometeorological data. 0. Getting started For the purpose of this introduction, we will assume that you will be using Matlab on a PC-Windows machine, although the appearance and functionality of Matlab is largely platform independent. Begin by starting Matlab from the Start menu. The command window will appear, and this is where you enter commands. Matlab is “command driven”, unlike Excel and most other Windows-based programs. In this document the symbol >> represents the Matlab prompt in the command window. Commands following it indicate that you should type these in; Matlab commands or responses are printed in Bookman Font. Pushing the Enter key causes the command to be executed. Matlab has extensive help resources, available under the "Help" tab of the MATLAB window, or type >> help topic. Hint Use the ( key to recall previous commands, which you...

Words: 3576 - Pages: 15

Free Essay

Internet of Things

...| Internet of Things | 2014| Pragya Vaishwanar | Aricent Marketing Research Report | Summary It’s fair to say that more people have heard of the “internet of things” than have experienced it. More objects are becoming embedded with sensors and gaining the ability to communicate. The resulting information networks promise to create new business models, improve business processes, and reduce costs and risks. There is breathless press coverage of the phenomenon—always patiently re-explained by tech pundits as the trend by which all of one’s most mundane possessions will become internet-connected. These are invariably coupled with estimates that the internet of things will be a multi-trillion dollar business. 2014 is really, finally the year that the “internet of things”—that effort to remotely control every object on earth —becomes visible in one’s everyday lives. In a sense the internet of things is already with us. For one thing, anyone with a smartphone has already joined the club. The average smartphone is brimming with sensors—an accelerometer, a compass, GPS, light, sound, altimeter. It’s the prototypical internet-connected listening station, equally adept at monitoring our health, the velocity of our car, the magnitude of earthquakes and countless other things that its creators never envisioned. Yet despite repeated declarations one of the most successful sellers of baubles that help make your home “smart,” Smart-things, has only shipped 10,000 or so units since...

Words: 13930 - Pages: 56