Question 3, Explain briefly the difference in activities among the following levels of information systems (IS) at a large organization: Operational level IS Tactical level IS Strategic level IS Give three example activities, each one handled by the corresponding IS, considering the three IS levels of a supermarket chain. Question 4 Explain briefly each one of the following relational DB concepts: atomic information, datatype, cells, columns, rows, flat file, primary key, foreign key. You can use an actual DB example to illustrate these concepts.

Question 3, Explain briefly the difference in activities among the following levels of information systems (IS) at a large organization: Operational level IS Tactical level IS Strategic level IS Give three example activities, each one handled by the corresponding IS, considering the three IS levels of a supermarket chain. Question 4 Explain briefly each one of the following relational DB concepts: atomic information, datatype, cells, columns, rows, flat file, primary key, foreign key. You can use an actual DB example to illustrate these concepts.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What defines a transitive dependency in a database table? A. One non-key attribute is functionally dependent on another. B. One non-key attribute is in first normal form. C. One key attribute is in first normal form. D. One key attribute is functionally dependent on another.
The project team will embark on a data take-on exercise because an operational system requires a fully populated database to support ongoing processing.Discuss how a DBMS interface works to extract data from a database
Based on BITS database user views as designed in Your Turn 6-1 in this chapter. In each exercise, represent your answer in DBDL and with an Entity Relationship Diagram. 2. Indicate the changes you need to make to the design of the BITS database to support the following situation. There is no relationship between clients and consultants. When a client places an order (service request), it may be performed by any consultant. On the order, identify both the client placing the order and the consultant responsible for the order.
I want to create logical database design: 1. Normalize the relations to at least third normal form (3NF) using proper standard E-R diagram notation. Provide the appropriate relational schema reduction. 2. Identify the primary and foreign keys for each relation (using appropriate notation). Maybe either list the primary and foreign keys or generate a schema diagram??? 3. Identify and describe any indexes needed to speed up searches on non-key attributes – can you explain it too? So I would understand why you come up with the answer please? 4. Identify and describe unique, conditional (check), non-null, referential integrity, or other constraints needed to guarantee the integrity of the database. 5. Describe the set of business or workflow rules applicable to your project. Next, describe at what point in the workflow you will implement the business or workflow logic and the justification for doing so.Below are my conceptual design.
Discuss how a DBA will verify that proper PK/FK relationships are established - do not forget the Associative Entity fix - e.g. certain default parameters are set, like NULL or NOT NULL, and when. You may want to explain what a DBA would have to verify if a given entity has more than one role within a system - read: is used in several relationships. Please help me answer this.
Convert the following ER diagram into a relational database schema, be certain to indicate primary keys and referential integrity constraints.
Convert the preceding ER diagram into a relational DB schema. (I want you to do this yourself, not using automated tools. You can use ERDPlus to construct the relational schema yourself, or you can do it yourself on paper and take a picture.) Indicate all primary keys correctly. Be sure to include arrows for foreign key relationships. Also make sure that all attributes in a single relation have different names. ER Diagram (DeviceName) Brand Model TicketNum DEVICE REPAIR TICKET Exhibits Nickname Assigned To PROBLEM TechID REPAIR TECHNICIAN Expert At Description Name PhoneExt Level
What is the objective of a business rule in data modelling? Actually, Data model is very important tool because it is something which is sued for designing the database for a DBMS and no DBMS can exist independent of any data model, now if we use a specific DBMS but are not sure about the data model it uses for data abase usage, we can not create a proper database. What is the objective of a business rule in data modelling?
Give two examples of each from daily life through relational schema: a. Primary key b. Foreign key c. Surrogate key d. Candidate key e. Composite key
A) Let suppose if you are a database designer, and if you were designing a Web-based System to make Online Coffee Shop for your friend and decide to sell coffee and deliver it, which DBMS architecture and model you choose and Why? Explain your answer with the help of other models. Identify entities, relationships, attributes while designing the database.(There should be at least five tables or more than that). List cardinalities on both ends of each relationship (0..1, 1..*, 1..1) - minimum 6 (2 for each relationship identified between entities)
Convert your ER diagram into relational database tables. List each table with all the fields, and identify the primary key and any foreign keys that exist.