Drops, Creates, Inserts, and a few Selects primarily, I believe the wording suggested that you can include triggers and views, but it wasn't compulsory.
I would have to check with Mehwish, but if you have your own test data, that may be sufficient, as long as its enough to show what you need to show.
ANONYMOUS wrote:
> Hi,
>
> I’m a bit confused about what exactly we need to submit in the .txt file. I understand we have to include the DROP statements and the CREATE TABLE statements, but do we also need to submit the sample data, simple queries, and complex queries?
>
> Additionally, I’m unsure where the assumption files should be placed.
>
> As mentioned here: "You also need to populate your database (INSERT INTO ...) with some sample data and perform some simple queries to ensure it works correctly. While doing so, I encourage you to try simple and complex queries and also practice the use of Views and Triggers."
>
> Does this mean we need to submit everything, including views and triggers?
>
> Lastly, if students are called in for a demonstration, will the database be tested against a standard set of data, or will we be using the data we populated ourselves? I’m concerned that there may be different interpretations of the project requirements.
>
> Thanks you so much for the assistance.