InfoSys Exam 1 Study Guide.
Transaction processing system data might be used for: - Answer- -Doing analysis on future student enrollment -Creating reports/queries for evaluating revenue amounts in an e-commerce sales system -Input into a BI analysis tool What are considered transactions in an information system? - Answer- -money deposited in a bank account -student registering for a class -customer adding an item to an online shopping cart What are some components of a database? - Answer- -tables -fields (attributes) -records (rows) A database for a company's transaction processing system for recording sales; should reflect? - Answer- -the companies specific business process rules A foreign key in a database table... - Answer- -is an attribute in a table ; its value must be a value from a primary key in another table Suppose that you have an Access database with a table named Sale Orders with the fields "OrderID", "TotalOrder$Value", "CustomerID (fk from customer table.)"; and; a table named Customer with the fields "CustomerID", CustomerName", "CurrentARBalance", and "CurrentCrediLimit".. I want a Customer-Sales query that lists all Sale Orders, and the CustomerName for each Sale Order. Which of the following are true. - Answer- - The 2 tables will be linked together with the CustomerID field BandID is the primary key in the Band table. The Bookings table needs BandID as a foreign key. You will not need to create an attribute in the Bookings table that will hold the BandID value; since Access will automatically create the foreign key attribute for you. - Answer- FALSE 1) Suppose that you have an Access database with a table named Sale Orders with the fields "OrderID", "Order$Value", "CustomerID (fk from customer table.)"; and; a table named Customer with the fields "CustomerID", CurrentARBalance", and "CurrentCrediLimit". How might you design a query to calculate the total $ value of all orders placed by each customer? - Answer- -Use a GroupBy and Sum for the Sale Orders table An IoT device: - Answer- -Often stores data in the cloud -Often communicates with other servers via the internet. Su
Información del documento
- Subido en
- 6 de septiembre de 2023
- Número de páginas
- 14
- Escrito en
- 2023/2024
- Tipo
- Examen
- Contiene
- Preguntas y respuestas