0
Database Design
Database design is the process of creating a detailed data model of a database. It is the next step after requirement gathering and before coding begins. A good database design can save a lot of time during the database development.
1,295 Questions
What is second normal form in DBMS?
Second normal form is valid in a table which have composite primary key which is made with the combination of two columns.So if we have A,B,C,D,E attributes in our table and C,D are fully functional dependent on A,B.But E is partially functional dependent on A,B,Mean if we use Only B to define E coloumn then that will be suffecent.so then we use 2nd normal form & we create two tables with coloumns attributes A,B,C,D and the other table with coloumns attribute B,E.That will be called second normal form.
What is the difference between OODBMS and DBMS?
Third generation of database design theory.
DBMS: Database Management System
RDBMS: Relational Database Management System
OODBMS: Object Oriented Database Management System
5 componets of an information system?
- Hardware: Physical components such as computers, servers, and networking devices.
- Software: Programs and applications that provide functionality for users.
- Data: Information that is stored, processed, and utilized by the system.
- Procedures: Guidelines and instructions for users on how to interact with the system.
- People: Individuals who manage, operate, and use the information system.
How business should store access distribute internal and external information?
The past two weeks, we have learned about Ancient Greece, the Roman Empire, and Islamic Empires. Answer the questions below based off what you have learned. There is no time limit and you will have two attempts at this quiz. The first attempt, you are not to use notes, or the PowerPoint. The 2nd attempt, you may use notes and/or the PowerPoints. Your grade will be the average of the two attempts.
If you have any questions, please send me a message in Canvas Inbox.
What are the disadvantages of a paper based system?
Disadvantages of paper based communication:
There are many benefits towards this communication method but they always come at a cost!
Issues arise as cost of sending away Via. stamps and delivery, other areas are the writers hand writing quality along with the grammar and spelling mistakes.
Some paper based methods do occasionally result in typed up letters printed off and sent away but these letters can include typo's, other mistakes, Etc.
Also when you send away a letter to another destination there is always the issue of the time taken to deliver it as it can take among weeks to even months on delivery and many times, the letter is either damaged or returned which can be again a huge issue!
Hope this short explanation is helpful
Advantages and disadvantages of relational database system?
A pivotal setup in designing a relation database is to design the relations making up the database. Although this might appear to be a simple task, many subtleties are waiting to trap the unwary designer. The Advantages to using a relational database system:
You use tables to create the relation. Inside the tables are primary and alternative keys.
The primary keys create the relation between the tables with the alternative keys. The disadvantage: You can lose information if the keys over lap in the requests made by the creator. Sometimes this is true and sometimes it is not. SQL is a type of database, is called structure query language. Which commonly is know to form the structure of the backbone for most relations database query systems. The popularity of this language is because the American Standard Institute standardized it. Another reason is that it was originally developed and marketed by IBM and has thus benefited from a high level of exposure.
When inserting character values into a table is case sensitivity important?
It depends on the database's collation settings. For case-insensitive databases, the case of the inserted values may not matter. In case-sensitive databases, the values are considered distinct based on their case, so 'John' and 'john' would be treated as different entries. It's best to know the collation settings of your database to handle character casing appropriately.
A database is used for storing your work and is a easy way to store information
A database is crucial for storing information, providing information to multiple users, easy access to data, fast information recall, and increased efficiency particularly for business owners.
Storing Information
A database is a type of file system that stores information. This is its most basic function. Instead of relying on traditional methods of storing information in physical file folders and cabinets, a database provides digital storage of information.
Providing Information To Multiple Users
Big advances in database technology allows multiple users to access and update information. This information will then be instantly viewable by all users. Not only does this enhance communication within a company, but it also ensures an informed and positive approach to customer service.
Easy Access To Data
A database manager provides easy access to information. Because the information is centralized, the user has no need to look to other applications or sources. All is provided through a singular database system, and the information in the database can be repurposed and fed into a company Web site or blog.
Fast Information Recall
Due in part to a series of complex algebraic algorithms that work together to recall information easily, querying a database should produce a quick result. When compared to locating the information manually, users find this quick recall an attractive feature of databases.
databases are used to store information from medical to personal.
you can use a database for
- recording results of a survey
- teaching
- bookings
A database is useful for storing information in it.
database are used to organise data into a more formal and understandable structure
Databases are used to reduce the redundancy and manage the data base of the employees more effectively and in a better way..
integrity of data can be provided , security of imp. data and easy retrieval of the desired information can be done
So database must be maintained to keep our data safe and secure....
A DBMS (Database Management System) is a software application that allows users to interact with a database. An RDBMS (Relational Database Management System) is a type of DBMS that organizes data into tables with rows and columns, and uses structured query language (SQL) for querying and managing data. RDBMSs are a subset of DBMSs, designed specifically for relational databases.
Is it true that third normal form removes transient dependencies?
Yes, third normal form (3NF) eliminates transitive dependencies by requiring that all non-prime attributes in a table must be determined by the primary key. This helps in reducing data redundancy and improving data integrity.
"Migdalia" is a feminine name of Spanish origin. It is believed to be derived from the Spanish word "migdal," meaning "tower." It is a unique and uncommon name.
What heroic action does Beowulf perform?
Lifting the Viking sword was the heroic action that Beowulf performed in the lair of Grendel's mother. It had been said that no ordinary man could lift the sword, but Beowulf lifted it and used it to kill Grendel's mother.
If you log into your own blog does Google analytics count that as a visit?
yes dear the google do analytics count that as a visit get it.
Can the FirstName column be a primary key?
A First name field is not a good one for a primary key. A primary key cannot have duplicate values. A first name field is highly likely to have duplicate values, so it should not be used as a primary key.
Why is database normalisation necessary?
Database normalization is necessary to eliminate data redundancy and ensure data integrity and consistency. By organizing data into multiple related tables and reducing duplication, normalization helps to save storage space and improve the efficiency of data retrieval and update operations. It also prevents anomalies, such as update anomalies and insertion anomalies, by ensuring that each piece of data is stored in only one place.
What is a structural independence?
Structural independence refers to a situation where two or more components or elements within a system are not dependent on each other for their functioning or operation. In other words, changes or failures in one component do not directly affect or impact the functioning of other components. This characteristic ensures that the system remains stable and resilient even when certain components are altered or fail.
What are the examples of fields in a database?
You could have a text field called Name. You could have a date field called Date of Birth.
What data validation can be used in a database?
A database is only as useful as the data it contains. Validation helps prevent invalid or inconsistent data from getting stored. At the most elementary level, it could be as simple are requiring a given element to only contain numerical data. More complex validation rules might entail a list of valid values, cross-field edits (if field A contains "xyz", then field B cannot contain "abc") and various more complex rules known as constraints (such as foreign key and NOT NULL rules.)
What are the objectives in enrollment system?
An enrollment system automated system in place by a college or school that allows the user to enroll in classes. The purpose of the system is to make the process easier for the student and the school.
How does the process of decantation work?
The process of decantation works by allowing solids to settle at the bottom of the mixture. This is a process that is used to separate mixtures.
This is a conventional system, the most used today; but for data bases is used the old Hill system where the formula is writed ClNa.
Why would a form be used in a database?
Forms are very crucial in daily life, it helps us to fill the details of particular matter and it is also an evidence.
