What type of privileges would a manager have to member data in a discount warehouse database?
Full Update
What is the problem in manual student attendance monitoring system?
It's not very effective and time consuming. Try Alosko - it's free and easy to use, plus it check geographical location of the students.
Stored procedures prevent unauthorized access to data
Is the relational database an example of oracle database?
A relational database is a type of database design. Oracle is a brand of database. You can create a relational database using Oracle. You can also create relational databases using other database applications.
Which is one of the four main operations of DBMS?
One of the four main operations of a Database Management System (DBMS) is data retrieval. This operation allows users to query the database and extract specific information using structured query languages like SQL. Data retrieval is essential for generating reports, analyzing data, and supporting decision-making processes.
Which one between logical and physical data independent is harder to achieve and why?
the logical data independence is hard to achieve because all the manipulation is belonging in logical data independence but in physical data independence only show the physical view .
"Evaluate a system" could mean several different things. I am somewhat confused as you asked this question under the following categories: Database Programming, Algebra and Calculus.
Under Database Programming, I am not sure. However, I would imagine it would mean to describe the effectiveness of the system that has been put in place. If this does not answer your question, you will have to be more specific and ask your question in plain and proper English.
Under algebra or calculus, "evaluating a system" would probably mean to determine the values of any unknown variables/constants in a system of equations or functions.
What are two main types of addictions?
substance addictions (for example, alcoholism, drug abuse, and smoking ); and process addictions (for example, gambling, spending, shopping, eating, and sexual activity).
Pg 222 in mis
What is the difference between conflict equivalence and view equivalence of dbms?
Conflict equivalence- Two schedules are conflict equivalent if the order of any two conflicting operations is same in both the two schedules.
View equivalence- Two schedules are view equivalent if -
1) Both the schedules have same set of transactions.
2) If in a schedule a read operation r1[X] of transaction T1 reads the value of X written by a write operation w2[x] of transaction T2 or reads the original value of x,then this must also be the case in the other schedule.
3)If operation w3[Y] of a transaction is the last operation to write the value of Y in schedule S then it must also be the last transaction in the other schedule to do so.
All conflict serializable schedules are view serializable.
But all view serializable schedules are not conflict serializable.
What is drawback traditional file system?
Two of the drawbacks of a traditional file system are that, at the limits, data cannot be found easily (you need to remember the pathname of the file) or quickly (the access time depends on where the data is in the file).
Stack
What did you mean by data representation explain it briefly?
Data is information that is interpreted by a collection (Representation) of explanatory words or symbols. A simple explanation is a 60mph sign at the side of the road. The figure 60 is the data while the sign embossed with 60 is the representation informing you of that which you need to know. Traffic lights are a representation that tells you by the data of different colours what you you need to know. @ is a representation of the data "at"
if your talking about what i am (hopefully) then well i am not sure but i think it is a long flat (well duh) sort of square file and its good for sofening edges, metal and wood edges that is.
Why would you sort a database?
You would sort a database to make it easier for a computer to recall information.
How is the system date changed in the medical manager system?
The date is changed after you have performed the Daily Close and are prompted to advance to the next date.
What are the main characteristics of a relational model?
The main characteristics of this "databases" is that the belief that what is mathematically elegant, is also the simplest and best. So the relational model is based on relational calculus, where you see the database as "relations" of tuples, where each tuple represent elements of data. You then go on and describe addition, subtraction (insert, delete), multiplication (join) and division (inner join) as operators on tuples, and projection as operators on elements. <p> This works fine, and a RDBM has to support integrity constraints that ensures that the mathematical properties are retained. If you do not like calculus, you can also describe the RDBMS with "relational algebra". A more pragmatic way of structuring data, that was intended to reflect the use of data can be found in the CODASYL DBTG proposal. Such databases will be vastly more efficient, there will be things you cannot do, whereas all can be done with a relational database - somehow.Note that a database as such is based on assumptions of support to retain consistency, data is supposed to never be lost, and when you make changes, you are able to "commit" them all because they are in the application logic defined so that it is not one, but all changes or none. If you do not manage to complete the application logic, every single trace of the changes is to be removed - "undone". A database shall also support multiple users at once, and see to that your changes are protected from others messing around with the data that you work on. This separate the various databases from using the plain file system. If you just make an application, the CODASYL database model will be much easier to work with, but when you later want to expand and add to the application, you will prefer to use the more general relational model, since this does not constrain you in any way.
What is a modification problem what are the three possible types of modification problems database?
The three possible types of modification problems are: Deletion, update, and insertion problems