0
I don't know physical design and logic design.đđđ
Please write the physical design and logical design of the database table. The data table (tb_User user information table) contains the field U_id user ID, UserName user name, Password user password, Level user level. I don't know if it's right, I don't know much about physical design and logic design. Just created a table containing the ID, name, password, and level. Create table tb_User ( Â Â Â U_id int, Â Â Â UserName varchar(100), Â Â Â Password varchar(100), Â Â Â Level varchar(100) );
1 Answer
0
Logical design
=============
Defining business entities, attributes for each entity, and relationships among entities. (you can search for ER diagrams and you will understand)
Physical Design
=============
Define tables, indexes, constraints, views which will be used.
(Search for Database Objects)