Question: I'm stuck on the coding part. If anyone has any input on how to get all seven SQL codes. The production company has elected to
I'm
stuck on the coding part.
If anyone has any input on how to get all seven SQL codes.
The production company has elected to go ahead and implement your design. At this time however, they have decided that they will not be tracking the animal actors that are used for the TV shows; if your database works well, they will possibly implement that data later on. The design that will be implemented is as follows: TVStations StationID Station Name H+ TVShows TVID TVName StationID EPISODE EpisodeID EName EAirDate Rating TVID ActorTVRole TVID ActorID StartDate TVRole EpisodeRole Episodeld OTVID Actorld Alternate Role H+ ACTORS Actorid AFName ALName [YrsActing] AgentID Actor Movies Actorld MovieID CharacterRole You have been promoted to the development team that will implement this design. As you've learned from your most current training, the first step in implementation is to create the structure of the database; the metadata. This must be created before you can actually populate the tables with the company's data. For this exercise, you will code the metadata (table spaces) necessary for each of the 7 entities above. Remember, from your training, that there are SQL coding rules that will be adopted as the protocol for this course. You will type your code in Notepad so that it can be easily copied to SQL Server at a later date. All 7 coded scripts, including comments to identify your tables, will be included in one notepad file which you will submit to satisfy the requirements of this exercise. Based on your training, list each table script in the correct order for successful implementation (which table should be implemented first, then second, and so on). Be sure to have the DBMS take care of entity and referential integrity for each table. Also resolve any issues with attributes that were not resolved during the design phase
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
