Posts by Wííl TR • 69 points
4 posts
-
5
votes2
answers2215
viewsQ: What is the difference between using a "Constraint" in "Foreign key" or not?
When creating a table in Mysql I used to create fields CONSTRAINT FOREIGN KEY how are you following to create the foreign key: CREATE TABLE socio ( id_socio INTEGER NOT NULL, nome VARCHAR(256) NOT…
-
-2
votes1
answer259
viewsQ: SQL SCRIPT PROJECT
Good afternoon, I have this project as a college job, I wish someone could give me a light, telling me if there is something wrong, or something I can improve. Follow the print of what is requested,…
-
-1
votes1
answer184
viewsQ: Can you help me?
I am with a project to be done, the project itself consists of creating an sql script based on entity model and relationship, the booklet itself is not very well formulated and based on what I…
-
-1
votes1
answer119
viewsQ: SQL SCRIPT WITH ERROR
Out of curiosity I took a report from my second semester of ADS and this course consists in making an SQL script based on 3 tables: ALUNO, CLASSE, MATRICULA. I made the script according to the…