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 Odpowiedź
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)