Attributes(Cont.............)

-
Attributes and Relational Data Models in ERP Systems

ERP Management System - Attributes and Relational Data Model

Attributes

Attributes are single-valued properties of either an entity-type or a relationship-type, such as last name, first name, MIS, address, and birth date.

Fig. 11.1

Relational Data Model

The relational data model provides conceptual tools to design the database schema of a relational database. It describes the data, relationships between that data, data semantics, and constraints on the data in the relational database.

Fig. 11.2
Previous Next

Comments

Post a Comment

Popular posts from this blog

ERP Management System Design

-
Image
ERP Management System Design Design and Develop Conceptual Data Model for an ERP Management System ER Diagram An Entity Relationship Diagram (ERD) displays the relationships of entity sets stored in a database. ER diagrams help explain the logical structure of databases, based on three basic concepts: Entities: Recognizable real-world things, either living or non-living, that are to be represented in the database. Attributes: Properties or details of an entity. Relationships: How entities interact with each other within the system. Enterprise Resource Planning (ERP) ERP is the integrated management of main business processes, often in real time, mediated by software. It is typically a suite of integrated applications that an organization uses to collect, store, manage, and interpret data from many business activities, and can be either local or cloud...
Read more

SQL WHERE NOT in SQL.

-
Image
SQL WHERE NOT Explanation Understanding the SQL WHERE NOT Clause The WHERE NOT clause in SQL is used to filter the results returned by a query based on conditions that do not match specified criteria. Essentially, it excludes records that match the condition. It is the logical opposite of the conditions that are typically specified with the WHERE clause. Examples Consider a database table named Employees with the following columns: Id - Employee's ID Name - Employee's Name Department - Department where the employee works Salary - Employee's Salary To select employees who do not work in the 'Sales' department, you would use the following SQL query: SELECT * FROM Employees WHERE NOT Department = 'Sales'; This query will return all employees whose Department is not 'Sales'. It effectively excludes all 'Sales' department employees ...
Read more

SQL IS NOT NULL.

-
Image
SQL IS NOT NULL Explanation Understanding the SQL IS NOT NULL Condition The IS NOT NULL condition in SQL is used to check for non-null values in a specified column. It helps in filtering the data by excluding rows where the column's value is NULL. Go To Download Examples Consider a database table named Employees with the following columns: Id - Employee's ID Name - Employee's Name Department - Department where the employee works Email - Employee's Email Address To select all employees who have an email address (i.e., where the email address is not null), you would use the following SQL query: SELECT * FROM Employees WHERE Email IS NOT NULL; This query returns all records from the Employees table where the Email column does not contain NULL values. Combining Conditions You can combine IS NOT NULL with other conditions to make more spec...
Read more