Logical design can be described as more conceptual and abstract design as compared to physical design. While looking into the logical design we establish the logical relationship among objects i.e. entity and its attributes. In relational database, entity is mapped to table name whereas attributes will its component. It helps to define the uniqueness of the table.
Note:- The sample assignment below is to make you aware on the kind of solution that can be when students ask us on DBMS homework help. We also tell you that the below solution is not our previous solved solution that we provided to our students in the past. We never reveal their solutions to other in order to maintain privacy on their assignment. Students from across globe visit our website and take help on dbms assignment, dbms query and theory help.
The aim of this task is to develop the logical design or model of inventory control system. The inventory control system includes different units like human resource, purchase, sale and stock management. The logical model will find all the main entities and their characteristics which we have to store the information.
- Product Category
- Item Brands