Essay about Data Dictionary

Submitted By 781252049

Words: 300

Pages: 2

Open Document

Sample Data Dictionary Table: CLASS
Field Name Access Data Type SQL Server Data Type Field Size Sample Data (realistic) Description/ Notes (only if required)
ClassNo Text char 5 C1234 PK. All same length. Start with a C
Day Text char 3 Wed
StartTime Text char 5 13.30
EndTime Text char 5 15.20
Semester Text char 11 Sem 1, 2008
CourseCode Text char 10 COSC 9821C FK to table COURSE
TeacherNo Text char 5 T9532 FK to table TEACHER
Fee Currency money N/A $150.00
MaxSize Number int N/A 25 Maximum no of of students to be enrolled

Table: ENROLMENT
Field Name Access Data Type SQL Server Data Type Field Size Sample Data (realistic) Description/ Notes (only if required)
StudentID Text char 8 S3123456 Part of composite PK. FK to table STUDENT
ClassNo Text char 5 C1234 Part of composite PK. FK to table CLASS
EnrolmentDate Date/Time datetime N/A 12-Feb-08 Medium Date in Access
PaymentMethod Text varchar 11 Credit Card Cash or Credit Card
CardNo Text char 19 1234 1234 1234 1234 FK to table CREDIT_CARD
Result Text char 3 CHD

Table: STUDENT
Field Name Access Data Type SQL Server Data Type Field Size Sample Data (realistic) Description/ Notes (only if required)
StudentID Text char 8 S3123456 PK All same length. Start with an S
Title Text varchar 4 Miss
LastName Text varchar 30 Cunningham-Smith
FirstName Text varchar 30

Essay Ramifications: Data Management and Inaccurate Data Kristine

of Inaccurate Data Kristine Miller A new focus on data capture is required like the skill to share electronic health records internally and externally with healthcare organizations and this has been accepted as a way to improve the value of care. Accurate data leads to quality information that is required for quality care and decision making. Inaccurate data threatens patient safety and can lead to increased costs, inefficiencies, and poor financial performances. To ensure the data is accurate it…

Words 368 - Pages 2

7000 wk 6 rough draft Essay

Consultancy Data Management System Karthik Goud Vulli Wilmington University Abstract The Project Consultancy Data Management System is a windows provision for robotizing, controlling and checking the operations in a consultancy. It primarily concentrates on the operations in a consultancy like enrolling the new members, including new courses, updating new information, hunt down courses & parts, and redesign courses for learners and encouraging launch & culmination of courses…

Words 1628 - Pages 7

Essay on Storage Optimization

.............. 8 Dictionary Only Add Column .......................................................... 8 Unicode Charactersets .................................................................. 9 Additional SAP Compression/Storage Benefits .............................. 9 Conclusion ....................................................................................... 10 Optimizing Storage in SAP with Oracle Database 11g Release 2 Introduction Using actual customer data, Oracle Database…

Words 4076 - Pages 17

Sample: Project Management and Development Cycle Essays

Systems Development Life Cycle •The Analysis Phase •Introduction to process modelling What is the System Development Cycle? What is an information system (IS)? Hardware, Hardware,software, software,data, data, people, people,and andprocedures proceduresthat that work worktogether togetherto toproduce produce quality qualityinformation information System—Set System—Setof ofcomponents components that thatinteract interactto toachieve achieve common commongoal goal Businesses Businessesuse usemany…

Words 1095 - Pages 5

Essay about Programm Logic

* Define the data * Define the outcome * Define the processes that will occur * Define the alternative solutions This chart is formulated to the items that are processed in the program with the formulas or expressions that is needed to solve the problem. So we would need this program to calculate a new balance for the checking account that has less than the minimum balance. If the balance goes below the minimum a fee will be subtracted from the account. GIVEN DATA | REQUIRED RESULTS…

Words 587 - Pages 3

Examples Of Online Transaction Processing

build business intelligence —Supported by data warehouses and data-mining tools RELATIONAL DATABASE MODEL: Database – collection of information that you organize and access according to the logical structure of the information Relational database – series of logically related two-dimensional tables or files for storing information —Relation = table = file —Most popular database model DATABASE- CREATED WITH LOGICAL STRUCTURES Data dictionary – contains the logical structure for the information…

Words 1401 - Pages 6

Fundamentals of Research Methodology Essay

RESEARCH METHODOLOGY Fundamentals of Research Methodology Psych/540 Dr. Stacey Soeldner Fundamentals of Research Methodology According to the American Heritage Dictionary, psychology is defined as the science dealing with the mind, mental and emotional processes, and the science of human behavior. Science is defined as systematic knowledge formulated through observations and study. Psychologists use the concepts…

Words 1078 - Pages 5

Descriptive and Inferentail Statistics Essay

estimation method, the example is used to estimate a parameter and a confidence interval about the estimate is built (RVLS, 2009). Then to make assumptions inferential statistics is utilized from data to more universal circumstances and descriptive statistics is used to explain what exactly is going on with the data. Psychological Examples The statistical information that psychologists use is received from testing. Descriptive statistics give a big picture of scores in any given group, measurements of…

Words 878 - Pages 4

Concept Of Terms And Concept

occurs when a subsystem achieves its goals while contributing to the organization’s overall goal Integration – when files are logically combined and made accessible to various systems. Data – are facts that are collected, recorded, stored, and processed by an information system Information – is data that have been organized and processed to provide meaning and improve the decision-making process. Characteristics of useful information – relevant, reliable, complete, timely, understandable…

Words 1339 - Pages 6

Unit 2.3 Assignment 1 Comparative Analysis

used to generate a pattern-based dictionary file from the original rockyou password list which contains 14,344,399 unique passwords. pbp-generator generated a pattern-based dictionary file that contains 2,247,786,433 (circa 2.3 billion) unique passwords. The new dictionary file contains 156 times more passwords compared with the rockyou list. Having two different password files (i.e. the original rockyou list and the generated pattern-based dictionary file), dictionary attacks are performed by using…

Words 762 - Pages 4