1. Write the definitions for the following terms
a. Table- 2 by 2 Matrix where you store all your data.
b. Record- is a row of data in a table, one sales event.
c. Row- one instant in a table is a prim.
d. Primary key- some data elements that is customized in a row. Like SSN.
e. Foreign key- a data element in a related table that is from a “foreign” table.
f. Compound primary key- are two or more primary keys are combined together makes a ‘compound’ key.
g. Query- is a function that seeks out questions posted in the database.
h. Entity- is an event or characteristic of something that a database will contain.
I. Attribute- are “characteristics” of an entity that contain more or more “relationships”.Ex. ( John Doe (Entity), Home and phone number, Home address (Attributes).
2. What are the categories or types of entities you would normally identify in your database design? Types of entities in a basic database are Employees, Customers, Inventories, Suppliers. Most databases are having organized tables that will individualize each entity with specific data.
3. What is a one-to-many relationship? The first entity is related to just one instance of the second entity. The first entity is related to many instances of the second entity, but each instance of the second entity is related to only one instance of the first.
4. What do you do in your database design if there is a many-to-many relationship between two entities?
Most D.M.S. only support one-to-many relationships so it’s necessary to implement relationship through cross-reference tables. Many to many relationships are cardinal references to the relationship between two entities. For example by adding two foreign keys with similar characteristics the primary key will become the many-to-many-relationship.
5. What are the 6 database design rules in your own words?
` 1) You will not need to table to categorize the business. A single database can represent the entire business. 2) Show the differences between entities in the business description. Distinguish between things and Events like products and revenue. 3) Describe
Related Documents: What Are The Categories Or Types Of Entities You Would Normally Identify In Your Database Design?
management information systems (MIS). It describes what MIS is and its purpose. The book basically breaks MIS down and talks about what it’s made of and the important resources within it. It is important for people to understand MIS in order to process and manage all information dealing with any technology tools in their organization. Another thing the book talks about is using customer relationship management (CRM) systems. Using customer relationship management systems helps organizations understand…
drugs etc Behaviour = actions, thoughts, feelings, memories and perceptions etc 1. Introduction to Biopsychology and the Nervous System Somatosensory cortex is an area of the brain that processes input from the various system in the in the body that are sensitive to touch – Pain and Temperature (detect pain, warmth and cold) The Nervous System responsible for coordinating all of the body’s activities controls maintenance of normal functions body’s ability to cope with emergency…
System: set of 2+ interrelated components that interact to achieve a goal Data: facts that are recorded and stored insufficient for decision making Information: processed data to provide meaning & improve decision-making process Characteristics of useful information Relevant – uncertainty, decision making, confirms/corrects prior expectations Reliable – free from error or bias, accurate rep of facts Complete – imp facts not omitted Timely Understandable – presented in useful &…
Chapter 7: Cognition Section 1 EQ: What is memory? -Memory = system that encodes, stores, and retrieves information -Human memory is COGNITIVE. The process by which information is processed by storing and using the memory is called information processing model. 1. Encoding ~the first thing memory does it encodes the incoming sensory info +requires that you select some stimulus from among the vast array of inputs ~Second it identifies the distincting features ~Third = you mentally…
Anatomical Planes Monday, September 20, 2010 3:43 PM Anatomical Planes Frontal/Coronal PlaneWhat Movements occur here? Transverse/Horizontal Plane What movements occur here? Median/Saggital Plane What movements occur here? Test Info Page 1 Anatomical Axes Thursday, September 30, 2010 12:52 PM Anatomical Axes • An axis is a straight line around which an object rotates. • Horizontal Axes• Longitudinal Axes• Antero-posterior Axes- The general rule is that the axis of rotation…
Lecture 1 Classification Systems of Motor Skills Open/Closed Open involves a very dynamic environment with changing factors that will impact a movement or action Closed is a controlled and unchanging environment that doesn’t impact a movement or action Gross/Fine Gross uses a very broad amount of movement or muscles, large movement Fine is very small, precise movement Discrete/Serial/Continuous Discrete is a single motion or action with a distinct beginning and end Serial is repeating the…
Satisfaction of customer needs and wants | Market Research | The systematic and objective process of gathering, recording, and analyzing data for aid in making marketing decisions-helps implement marketing concept-provides managers with continuous info needed to determine 4 p’s 1.) broad general scope- all disciplines dealing with data2.) systematic- follows the scientific method, measurable and repeatable3.) objective | Role of Marketing Research | -effective decision making-creates value for…
modified b. Most remodeling occurs at synapses (the piece between the end of one neuron the beginning of another neuron) -stimulates the brain c. Changes are activity dependent; connections between synapses must be reinforced to maintain useful info C. Use it or lose it a. Remodeling or neuronal plasticity is essential for establishments of memories b. Activity dependent; results in addition or loss of synapse: net effect is increased signaling between certain synapses and reduced/loss…
1. Name at least five applications and tools pre-loaded on the TargetWindows01 server desktop, and identify whether that application starts as a service on the system or must be run manually. WINDOWS APPLICATION LOADEDSTARTS AS SERVICE Y/N 1. tftpd32 Starts as a service 2. FileZilla Server Interface- The interface does not start as a service and must be ran manually 3. Wireshark – Does not start as a service and must be ran manually 4. Nessus Server Manager – Does not start as a service and…