Database Creation

Hi All

Are we allowed to use Web Editor phpMyAdmin to create our own database..?

That is the fastest and easiest way to create your database. You can use a script also, but it is far easier with phpMyadmin.

I am very familiar with databases and running sql scripts, just want to know if I can use phpMyAdmin.
The thing is I don't need to test my self on using scripts

Yes you can. You will only submit your php files, not your database files.

Thanx AlexB

Hi there,

The course_student table seems to be a major key as to whether the " The Portfolio " functions properly or not.
I have a little database experience, but the correct use of the table with the Many to Many relationship as well as
maintaining Referential Integrity I'm finding difficulty with. Would it be out of place to open a discussion on this rather
than ask a specific question?

CharlesU

As its stands, and I am not implying that wrong approaches are taught, the db has been set up to force you to learn certain coding skills (e.g. using joins - but I will not penalize you for not using joins in an introductory course).There are many outstanding issues which we cannot possibly hope to cover in a short course (let alone a full course - which is why my diploma courses stretches over 2 semesters). Referential integrity and db normalization are just two issues - but they are not easy to teach nor learn. This course therefore focuses on basic coding skills (and logic). That said, you are required to state "improvements" in a document - whether it be code or db related. This counts 20% of the mark.

You are most welcome to open a discussion! But first - what is wrong in this db schema below - primary key first column in every table

Language: PHP
CREATE TABLE categories (
  categoryID    
  categoryName     
);
 
CREATE TABLE products (
  productID        
  categoryID    
  productCode      
  productName      
  listPrice       
);
 
CREATE TABLE orders (
  orderID     
  customerID     
  orderDate      
);
 
CREATE TABLE categories (
  categoryID      
  categoryName     
);
 
CREATE TABLE products (
  productID      
  categoryID      
  productCode     
  productName      
  listPrice       
);
 
CREATE TABLE orders (
  orderID        
  customerID    
  orderDate      
);
 
CREATE TABLE customers (
  customerID       
  emailAddress    
  password          
  firstName        
  lastName        
  shipAddressID    
  billingAddressID    
  );
 
CREATE TABLE addresses (
  addressID         
  customerID     
  line1             
  line2             
  city            
  state             
  zipCode           
  phone             
  disabled          
  );
 
CREATE TABLE orders (
  orderID         
  customerID        
  orderDate        
  shipAmount        
  taxAmount        
  shipDate          
  shipAddressID     
  cardType         
  cardNumber        
  cardExpires       
  billingAddressID  
);
 
CREATE TABLE orderItems (
  itemID   
  orderID          
  productID  
  itemPrice   
  discountAmount  
  quantity       
  );
 
CREATE TABLE products (
  productID     
  categoryID       
  productCode  
  productName     
  description      
  listPrice        
  discountPercent  
  dateAdded        
 );
 
CREATE TABLE categories (
  categoryID      
  categoryName     
);
 
CREATE TABLE administrators (
  adminID    ,
  emailAddress    
  password        
  firstName     
  lastName        
);

Hi Prof mac,

When you lay it out like that, things do look a lot simpler. Happy you picked up what was really worrying me!
Anyway the tut letter states: First priority is that it must work, I'm sure I can get that right. Then I'll go for detail.
Look forward to taking the next course, which will be over at least a year.

Thanks,

CharlesU

Hi ,

This JOIN produces this: "Surname_ ". Is the JOIN incomplete or is another JOIN required to display the courses?
I've used full table names to keep track of what I'm doing!

Language: PHP
$query =

Language: SQL
    "SELECT student.sname,course_student.cid " .
     "FROM student LEFT JOIN course_student " .
     "ON course_student.cid=student.sname ";

Language: PHP
$result = mysql_query($query)
  or die(mysql_error());
 
  while ($row = mysql_fetch_array($result)) {
  print $row[';sname';]."_".$row[';cid';];
print"<br/>";
}

A course id can never be equal to a surname ...

Hi.

Just one Question regarding the Course_man is the database.

The course_man should also be updated when a new student registers for a course.

the fields sno= the students AUTO_INCREMENT number cid= Course AUTO_INCREMENT number, year= the day the user registered?

The course_man page is just for keeping details of all your courses. So when you add and delete courses this happens on this page and this will also affect the database connected to the fields that you need to provide.

The course_student table holds all your registration information.






78185106 Wrote:
-------------------------------------------------------
> Hi.
>
> Just one Question regarding the Course_man is the
> database.
>
> The course_man should also be updated when a new
> student registers for a course.
>
> the fields sno= the students AUTO_INCREMENT number
> cid= Course AUTO_INCREMENT number, year= the day
> the user registered?

___________________________________________________________________________
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning...

Hi Thanks

sorry I meant the course_student

The year the student does the course (we assume it is year courses)