gammaman Posted April 22, 2008 Share Posted April 22, 2008 I know this is the wrong place but I don't know where to ask. If anyone wants to help me normalize three tables, please post here. Link to comment https://forums.phpfreaks.com/topic/102310-help-with-normalization/ Share on other sites More sharing options...
gammaman Posted April 22, 2008 Author Share Posted April 22, 2008 Here are my tables. +-----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+----------------+ | studentID | int(5) | | PRI | NULL | auto_increment | | lastName | varchar(15) | | | | | | firstName | varchar(10) | | | | | | phoneNUM | varchar(10) | | | | | | password | varchar(15) | | | | | +-----------+-------------+------+-----+---------+----------------+ +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | courseID | varchar(6) | | PRI | | | | courseName | varchar(12) | | | | | | seatLimit | int(3) | | | 0 | | +------------+-------------+------+-----+---------+-------+ +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | CourseID | varchar(6) | YES | | NULL | | | CourseName | varchar(20) | YES | | NULL | | | StudentID | int(3) | | PRI | 0 | | | Password | varchar(15) | YES | | NULL | | | Grade | char(2) | YES | | NULL | | +------------+-------------+------+-----+---------+-------+ Link to comment https://forums.phpfreaks.com/topic/102310-help-with-normalization/#findComment-523855 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.