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) );

25th Oct 2018, 8:43 AM
Echo.Yan
Echo.Yan - avatar
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)
16th Nov 2018, 2:57 PM
Prokopios Poulimenos
Prokopios Poulimenos - avatar