I am designing a database based on netflix could someone give me idea of what the entities and attributes of the table would be? How would I set up it according to specifics below. Thanks.
The cudstomer signs up for one of the program (3 at a time program)
The customer will be able to add to their movie que
Then requests movies from their que
customer watches and returns movie to netflix
netflix mails out additinal movies to customer
customer closes account and does not return movie and is charged a few.
By reading your question - I feel, you need these much tables. It is clear about foreign key required from the below table structures - Go through and let me know.
Table1 - tblCustomer
Columns - CustomerID
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.