This is questions of Accounting Information Systems
1.B = Record
Four Tet industries track customer information using various Microsoft excels spreadsheets stored in a database each row in a spreadsheet represents the record.
2.B = Primary Key
A database filed in table 1 that serves as a unique identifier in table 2 and is used to link both of the tables is a primary key.
3.C = The Primary Key in the second table
4.D = Foreign Key Rule
The database requirement that foreign keys if not null must have a value that corresponds to the value of the primary key in another is called the Foreign Key rule
5.B = Data Manipulation Language ( DML )
Data Manipulation Language builds the data dictionary, defines the record structures of the database and it specifies the record and the field security constraints.
This is questions of Accounting Information Systems 1) Fo a database. Each row in this spreadsheet...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....
DATABASE SYSTEMS PLEASE HELP ME FOR QUESTIONS 1 THRU 2 SHOW THE QUERY AND THE RESULTS OF THE QUERY (OUTPUT IN TABLE). ALSO, SHOW THE COMMANDS TO CREATE EACH TABLE (DDL COMMANDS) AND THE INSERTION OF THE DATA FOR EACH TABLE (DML COMMANDS). Question 2: SQL (40 points) Use the following database to answer all parts of this question: Table: EMP Primary Key: E NO E NO E NAME E DEPT E RATHE $400.00 $200.00 $150.00 $150.00 S120.00 $100.00 $100.00...
Please do not delete the questions. 1. What is the purpose of a database? 2. What is the reason to use a database over a spreadsheet? 3. Based on the previous answers (#1 & #2), there is a simple rule of thumb. A spread sheet is used when there is _________________________. A database is used when there are _________________________. 4. Please answer followings. a) A group of 8 bits is called a ____________ (from Chapter 4). b) The answers of...
Please access to TUN SQL/Assistant using the default database = db_pvfc12_std 1.- Run a query to retrieve all the data field from db_pvfc12_std in table CUSTOMER_T 2.- Run a query to retrieve record --> CustomerID = 11, How many records did you get and why? 3.- Run a query to retrieve all the data field from table Order_T Once retrieved: 3.1.- Please name the fields showing: Primary Key, Foreign Key and other fields 3.2.- What type of...
(MMU) has decided to consolidate the functionality of three small overlapping database systems, which support applications for 1) teaching (e.g. instructor assignment and evaluation), for 2) registration (e.g. online course status, waiting lists), and for 3) student records (e.g. transcript generation) The resulting new system will support the following enterprise description: Professors and GTAs are assigned to teach the sections of each class being offered in a semester. At the end of the semester, they get a "team rating" (professors...
1. Define and provide examples of the following terms. Use 3-5 sentences for each term. (30 points) a. Health Informatics b. Data Quality Management c. Interoperability d. Data Lake e. Data f. Information g. Standardized h. Unstandardized i. Data Standard j. Health Information Exchange (HIE) k. Relational Database l. Primary Key m. Foreign Key n. Structured query language (SQL) o. Information Governance 2. Differentiate the difference between information governance and data governance. Provide examples of how you would implement both...
Relational Database Design Theory, please answers ALL parts because they are related to each other, and I can't separate it into different questions. Please help! By looking at the PHLogger table: A. List all non-trivial functional dependencies. B. What is the highest normal form the PHLogger table is in currently? C. The external consulting experts at DBInstructor, Inc., have noticed that city and state of an address can be inferred by its postal code (zip code). What new functional dependencies...
database and sql problme THE QUESTIONS 3, 4,5 and 6 REFER TO THE RELATIONAL TABLES LISTED BELOW CREATE TABLE Department ( DECIMAL(5) VARCHAR(30) CHAR(5) DATE NOT NULL NOT NULL NOT NULL * Department number /*Department name * Department manager number */ /Manager start date DNumber DName Manager MSDate CONSTRAINT Department_PK PRIMARY KEY(DNumber) CONSTRAINT Department_CK UNIQUE(DName) CREATE TABLE DeptLocation DECIMAL(5) VARCHAR(50) NOT NULL NOT NULL DNumber * Department number */ * Department location */ Address CONSTRAINT DeptLocation_PK PRIMARY KEY(DNumber, Address) CONSTRAINT...
Questions: Fill in blank 2. Superglobal variables, such as $_COOKIE or $_POST are actually and not variables. 4. A unique identifier in a database is known as the True or False 6. T/F A cookie can only be retrieved by the server that set it. 8. T/F A cookie can be set in any place on an HTML page. 10. T/F The isset() method only returns true or false. 12. T/F The field attribute in a MySQL database that is...
4. The exams database: The following database contains multiple choice exam questions tables Questions and On Hons). Each question has a question Tert and each one of the options has and optid, which is an integer representing options A) (optid=1), B) (optid=2), C) (optid=3), etc. as well as the text of the option. The field correct is either Oor 1 and indicates which is the correct option for that particular question. courseThe exams have numbers 1, 2, 3, etc. Each...