can anyone help me to create a database for cable television system?

Question

hi everyone im a 4th yr college students taking up computer science nd creating a database is one of our project this sem. can anyone help me do the database for cable television system. I choose the language Microsoft Visual Studio . Net. I am not familiar with this language for our professor said that we have to use a new language so thats it..Any help will do thanks

Answer 1

Think about the program guides that you probably have already on the cable system in your area. I'm sure you have watched them at some point and needed to find information about a program. If you have a digital cable system, check out the interactive guide for ideas on search and categories as well.

Basically you are looking to capture the following (certainly not a complete list...not doing all the work for you, just getting you started):
- program name
- start date/time
- end date/time
- program description


Keep in mind that program names are not going to be unique and may occur on multiple channels at multiple times (i.e. "The Simpson's" is on in my area on several channels at several different times in a single day)

Think about how you'll have to normalize the information to efficiently store the data in your database.

What database are you using anyways? Oracle, MS SQL, MS Access (not much of a DB in my opinion, but should suffice for a simple problem like this), MySQL, etc..?

How will your interface interact with the database? ODBC, JDBC, other?

Is the interface web based or desktop based? Take a look at MVC (Model-View-Controller) and consider a page flow if going web based.

Answer 2

The purpose of the assignment is to get YOU to choose and learn a new programming language.

You are already trying to cheat before you found a new language, shame on you.