What are the steps of attribute of software model designing?

What are the steps of attribute of software model designing?

First of all we considered the software model as according to the database then we consider the steps of attribute of the software model.

What is the software model in according to the database?

Software model is to understand by the skeleton structures of the software called schema. The Schema is define basically the two main structures are logical structure and Physical structure. Schema is define that the relation of their entity, attribute, processing structure, function, logical structure and Physical structure.

1. A typical model of software has their entity, attribute, conditions, functions, connection of the database etc.

2. A software has Input and output structure and their interface design.

3. A software has their database structure or database connectivity.

4. The Admin and the End user interfaces design of the software model have its security access to protect the data or any RDBMS information.

5. The security of the software protects their company data.

6. Accessing of networking must need for the software.

7. A Module is to design for the software to solve basically the original problem of the specific tasks.

8. Here the database of the software is managed by the Key attributes which is given below the typical steps.

Steps of attribute in typical model of software

1. Step 1

Use Primary Key

First you can use the primary key to identify uniquely the database which is in the form of table.

Suppose you can use to see the record of LHS (Left Hand Side) table and RHS (Right Hand Side) table by using the basic condition.

For example:

SELECT id no., Employee_name, Address;

From * Table; \\ both side of the table

Where ( id = 1);

This condition is use to retrieve the data from both the table and the result is

( 1, abhishek Avasthi , Uttarakhand, India)

Here is code from MS SQL server 2008. It is used as database for software developing.

Here in the figure above Id no., employee name, address fields are the three column and their records which is represents in the rows of table. Column is to understand the attribute of the recorded data.

In the table Id number is must be needed for the every data base of the tabular form because the sequential data is very easily to retrieve the data from the table’s record.

2. Step 2

Use Candidate key

If you have problem in tabular database such as all employees are admins and their admin_id number than you can use candidate key because admins numbers may be are look like Id number of their employees.

Here in the figure above Id number, employee name, address and admin numbers are in the form of the table. The admin numbers are used in the sequential form. So you can retrieve their record by the candidate key.

By using the ‘select’ command as given above in the step 1.

3. Step 3

Use Super key

If you have a problem in the tabular data in the employees name and their address field’s values are the same as a part of the primary key then you can use Super key.

In the above Figure to show the Super key detects their Employees name and addresses are same or not.

4. Step 4

In another way you can use Composite Key

In other way when Primary key is not identify uniquely the database in the table record then you can add new field or column or attribute of the record to identify uniquely by the use of Composite Key.

In the above figure Composite Key attribute to composite or merge two databases and new database created which is used to help the uniquely identify the record of the database from the new created table.

5. Step 5

For instant data you can use Secondary Key

a) Secondary key is use to classifies the data in table database.

b) It classifies the instances of employee entity set such as their department name which is the attribute of employees in a field or column.

Secondary key is use to identify by the department in the above table. Secondary is used as the strong attribute which is show in the figure above.

6. Step 6

Use Foreign Key

a) Foreign Key is use widely because according to employees departments in any company employees record the most of employees have their one department but some employees have their two departments with different works.

b) In the above figure “Foreign Key” may be the primary key from another department because their data have corresponds to.

------------------------

MCQ questions related to the steps of software attributes....

------------------------

Which basic key attributes are used to find the record from the relational database model in the application software?

A) Foreign key

B) Composite key

C) Super key

D) Primary key

Answer is D) "Primary key"

The primary key basically used first to uniquely identify the record and most powerful key in the relational database model.

The find record using the select command is used to find the record from the database file.

When the user applies the select command in the relational database model then the user needs to mention the "user id number" which is known as the primary key mentioned in the relational database model. For example:- "Select user_id_num = 089;" .

Then the select command works on the database file and provides the record which has the user id number is 089.

-----------------------------------------------------------------------------------------------------------------------------

computers-achievers

Search This Blog