Posts by seslie

Hi King03,

E and M are known as Aliases. You can give a table or a column a different name through the use of an alias. This is useful and helpful if you have very long or complex table or column names. An alias name could be anything, but usually it is short and they can make queries easier to read and write.

You could google and read more about Alias in Sql

Hello king03,

In addition to rch1231's response,
The table contains some data that you arent showing here. You are to majorly perform a 'select' query, whose syntax you should be familiar with. for e.g

SELECT [column_name]
 FROM [table_name]
 WHERE (column_name = condition);

For the first question,
List 'Sold' transactions for customer 1003 for September with the Rental transactions for customer 1011 for October. Display Customer Name and product description/movie title with transaction type and month.

You'd be getting this information from different tables; CUSTOMERS, PRODUCT, MOVIE and TRXN.

This tells you that you'd need a form of connection between theses, which has already been established. Something like this should give you a good idea on how to go about it.

Customer  Trxn_Type  Trxn Date        Product Desc   Movie Title
Rancid     Sold      sept something    Very good      Avengers
Sola       Rental    Oct something     Also good      Dark Knight


Select ...
from  customerTable c, trxn t, movie m, product p
where (c.cust_code = 1003
      and c.cust_code = t.cust_code
      and t.trxn_type = 'SOLD' 
      and p.movie_id = m.movie_id)

or    (c.cust_code = 1011
      and c.cust_code = t.cust_code
      and t.trxn_type = 'RENTAL'
      and p.movie_id = m.movie_id);

I'm not sure this is very efficient though, Just to give you an idea.

Glad I could help. You're very welcome.

Hello HunainHafeez,

please see this link http://www.daniweb.com/web-development/databases/threads/430095/user-roles

Regards

Hello akkbkht,

From what i understand, you can do this by having, for example, a MEMBER_ROLE table e.g

roleID | roleName | Description
  1      Admin      Administrator
  2      Applicant  bla bla bla

and ofcourse, you have a member table..

memberID | firstName | lastName | roleID(fk)
 1         Beautiful    You         2
 2         akkbkht      Daniweber   1

Then you could write your queries to suit this...e.g
check this member with memberid 2, is he an admin? if yes, allow access somewhere, else, deny.
Hope this helps you.

Regards,
Seslie

Hi kahindi ,

What are you interested in? Do you want to create a web based system (probably the easiest of them all) or a mobile app, or something on networking, or graphics?? There's a whole lot to do.
1.You could also see past projects. There's usually a section that contains information on further work to be done. You could improve on it.
2. Search this forum, there's a lot of materials that can help you.

Hello sanghvikevin,

Try looking up this link..http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm.

There's a section that explains your question..'The RR Datetime Format Element '

If you still don't understand, post back for extra details.

Regards,

Seslie ;-)

Hello caltech,

what i usually do before i begin any of my applications is to sketch how the interface is gonna look like on a piece of paper, somehow this helps me figure how to design the database...

So, also wanted to ask about the schedule. Is it static? for example; for the period employee xy is with us, he'll work every mon, tue and sat? or u have something like this;
for the period this employee is with us, he'll work on mon morning tue evenings and sat mornings for the first few weeks and would be changed..do u understand what i mean?

Hello Shapam,
That's good to know, please could you post how you got the problem solved, so I and others can benefit from it? Thanks and also mark as solved once you do.

And just for a later time, try to avoid using the word 'Help!' alone as a topic for your thread...