(a)
Define Data.
Explanation of Solution
Data are the raw facts and are referred to as the stored representation of events and objects that have importance and meaning in the user’s environment. Data can be structured or unstructured.
(b)
Define Information.
Explanation of Solution
Both the data and information are closely related to each other. Information is the data that is processed to increase the knowledge of a person who uses that data.
(c)
Define Metadata.
Explanation of Solution
Metadata is the data that describe the characteristics or properties of data used by the end user and the context of those data.
(d)
Define Enterprise resource Planning.
Explanation of Solution
Enterprise Resource Planning is a process of managing businesses. This process is used by many organizations to manage and integrate different parts of their businesses. It integrates all the important factors like product planning, manufacturing, development and sales.
(e)
Define Data Warehouse.
Explanation of Solution
Data Warehouse is a collection of large amount of data and information from different sources and management of that data to provide meaningful business insights.
(f)
Define Constraint.
Explanation of Solution
Constraints are used for specifying rules for the data in a table. It is used to limit the type of data to ensure reliability and accuracy of the data.
(g)
Define
Explanation of Solution
Database is a collection, organization, storage, update and access of data. Database makes data management easy.
(h)
Define Entity.
Explanation of Solution
Entity can be a place, person, object, concept or event in the user environment about which the organization wants to maintain the data.
(i)
Define Database Management System.
Explanation of Solution
Database management system is a software system that is used to create, store, update, retrieve, maintain and access user databases.
(j)
Define Data lake.
Explanation of Solution
Data lake is referred as a repository that stores a large amount of raw data in its native format. Data lake can store structured or unstructured data. Data lake stores data using a flat architecture.
(k)
Define System Development life cycle.
Explanation of Solution
System Development Life Cycle is a traditional method used to develop, maintain and replace
(l)
Define Prototyping.
Explanation of Solution
Prototyping is an iterative process involved in systems development in which there is a conversion of requirements to a working system which is revised continually through close work between users and analysts.
(m)
Define Enterprise Data Model.
Explanation of Solution
Enterprise Data Model creates an overall explanation and image of organizational data and not for a particular database. It may involve many databases and describes the scope of data maintained by the organization.
(n)
Define Conceptual Data Model.
Explanation of Solution
Conceptual data model is a detailed and technology independent specification of the overall structure of data of organization.
(o)
Define Logical Data Model.
Explanation of Solution
Logical data model is a data model that describes the data in a detailed format without considering how the data is physically implemented in the database.
(p)
Define Physical Data Model.
Explanation of Solution
Physical data model describes how data from logical data model is stored by a database management system. A physical data model consists of table’s structure that includes column name, primary key, constraints, data type and relationships between tables.
Want to see more full solutions like this?
Chapter 1 Solutions
Modern Database Management
- Python - need help creating a python program that will sum the digits of a number entered by the user. For example if the user inputs the value 243 the program will output 9 because 2 + 4 + 3 = 9. The program should ask for a single integer from the user, it should then calculate the sum of all the digits of that number and output the result.arrow_forwardI need help with this in Python (with flowchart): Im creating a reverse guessing game. Then to choose a random number from 1 to 100 and the computer program will attempt to guess it, displaying the directions calculated or not. The guess will be displayed and the user will answer if it was correct or not. If correct, the game ends, if not then the computer asks if the guess was too high or too low. Finally inputting an answer and the computer generates a new guess within the proper range. Oh and to make sure the program doesnt guess outside of the ranges produced by the inputs of “too high” and “too low”. The program ending when the user guesses correctly or after the program takes 6 guesses. HELP ASAP!arrow_forwardI need help with this in Python (with flowchart): Im creating a reverse guessing game. Then to choose a random number from 1 to 100 and the computer program will attempt to guess it, displaying the directions calculated or not. The guess will be displayed and the user will answer if it was correct or not. If correct, the game ends, if not then the computer asks if the guess was too high or too low. Finally inputting an answer and the computer generates a new guess within the proper range. Oh and to make sure the program doesnt guess outside of the ranges produced by the inputs of “too high” and “too low”. The program ending when the user guesses correctly or after the program takes 6 guesses. HELP ASAP!arrow_forward
- Need help finding errors in my pseudocode (Two)! Declare Boolean finished = False Declare Integer value, cube While NOT finished Display "Enter a value to be cubed." Input value; Set cube = value^3 Display value, " cubed is ", cube End While Next, I intended the following pseudocode to display the numbers 1 through 60, and then display the message "Time’s up!". Doesnt work and has error. Declare Integer counter = 1 Const Integer TIME_LIMIT = 60 While counter < TIME_LIMIT Display counter Set counter = counter + 1 End While Display "Time's up!"arrow_forwardHaving error in pseudcode; wanting to get five sets of two numbers each, calculate the sum of each set, and calculate the sum of all the numbers entered. Not functioning as intended and can't find the error.Code: // This program calculates the sum of five sets of two numbers. Declare Integer number, sum, total Declare Integer sets, numbers Constant Integer MAX_SETS = 5 Constant Integer MAX_NUMBERS = 2 Set sum = 0; Set total = 0; For sets = 1 To MAX_NUMBERS For numbers = 1 To MAX_SETS Display "Enter number ", numbers, " of set ", sets, "." Input number; Set sum = sum + number End For Display "The sum of set ", sets, " is ", sum "." Set total = total + sum Set sum = 0 End For Display "The total of all the sets is ", total, "."arrow_forwardNeed help converting loops!1. Convert the following While loop to a For loop: Declare Integer count = 0 While count < 50 Display "The count is ", count Set count = count + 1 End While _________________________________________________ 2. Convert the following For loop to a While loop: Declare Integer count For count = 1 To 50 Display count End Forarrow_forward
- Need help making this!1.Design a nested loop that displays 10 rows of # characters. There should be 15 # characters in each row. 2. Design a nested set of for loops that displays the following arrangements of ‘X’ characters X XX XXX XXXX XXXXX XXXXXXarrow_forwardI need help to resolve the case, thank youarrow_forwardIn 32-bit MSAM, You were given the following negative array. write a program that converts each array element to its positive representation. Then add all these array elements and assign them to the dl register. .data myarr sbyte -5, -6, -7, -4.code ; Write the rest of the program and paste the fully working code in the space below. the dl register should have the value 22 after summing up all elements in the array.arrow_forward
- Microprocessor 8085 Lab Experiment Experiment No. 3 Logical Instructions Write programs with effects 1. B=(2Dh XOR D/2) - (E AND 2Eh+1) when E=53, D=1Dh 2. HL= (BC+HL) XOR DE (use register pair when necessary), when BC=247, HL 516, DE 12Ach 3. Reset bits 1,4,6 of A and set bits 3,5 when A=03BH Write all as table (address line.hexacode,opcede,operant.comment with flags)arrow_forwardIn 32-bit MASM, Assume your grocery store sells three types of fruits. Apples, Oranges, and Mangos. Following are the sale numbers for the week (7 days).dataapples dword 42, 47, 52, 63, 74, 34, 73oranges dword 78, 53, 86, 26, 46, 51, 60mangos dword 30, 39, 41, 70, 75, 84, 29Using a single LOOP instruction, write a program to add elements in all these three arrays. Then assign the total result into the eax register. The eax register should have the value 1153 after a successful execution.arrow_forwardYou were given the following negative array. write a program that converts each array element to its positive representation. Then add all these array elements and assign them to the dl register. .data myarr sbyte -5, -6, -7, -4.code ; Write the rest of the program and paste the fully working code in the space below. The dl register should have the value 22 after summing up all elements in the array. Your answer must be in 32-bit MSAM.arrow_forward
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning